SQL Server Transaction Logs
If I change the recovery model on the primary database from full to simple and then change the primary database back to full again. Would that break the log chain? It seems the log shipping breaks after we do that.

Answer Question   |  August 18, 2009  2:11 PM
SQL Server 2005, SQL Server backup, SQL Server log shipping, SQL Server logs, SQL Server transaction logs

sql server 2000 how can i make backup 4 file only and restore
how can i make backup 4 file only and restore

Answer Question   |  July 28, 2009  2:08 PM
SQL Server 2000, SQL Server backup, SQL Server backup and restore

Backup failing
Hi Mrdenny, I have as GIG. I have a Database Full Backup Maintenance Plan that fails to execute, and I get the same error as GIG’s. I checked my disk and I think there is enough free space available (471GB). What could be causing the full backup to fail? Please help! Thanks in advance.

Answer Question   |  July 10, 2009  2:48 AM
SQL Server backup

Error backing up with SAP transaction DB13
The following error message occurs when I attempt to backup with SAP transaction DB13: ***************************** SQL Job information ****************************** Jobname: SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326] Type: TSQL DB-Name: RPD For Run: 20090620 09:43:26 **************************** Job history information ***************************** Stepname: CCMS-step 1 Command: declare @exeStmt nvarchar(2000) exec rpd.sap_backup_databases @dbList= “master,RPD”,@r3Db=”RPD”,@bDev=”R3DUMP0″,@expDays= 27,@jobName= “SAP C [...]

Answer Question   |  July 6, 2009  5:21 PM
DB13, NTBackup, SAP Transactions, SQL Server 2005, SQL Server 2005 backup, SQL Server backup

Software to automate backups for SQL Server 2008 databases
I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up [...]

Answer Question   |  June 29, 2009  4:44 PM
Automated backup, Backup & recovery, Backup software, SQL managment Studio, SQL Server 2008, SQL Server backup, SQL Server backup and restore, SQL Server Management Studio

Backing up SQL Server 2008 databases to a tape drive
I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

Answer Question   |  June 25, 2009  10:36 PM
Backup to Tape, SQL Server 2008, SQL Server backup, SQL Server database, Tape Backups

MS SQL SERVER (BKUPEXEC) Services wont start
Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my SQL [...]

Answer Question   |  July 13, 2009  2:22 PM
CHKDSK, MSSQL$BKUPEXEC, SQL Server 2005, SQL Server backup, SQL Server Services

Transaction Log – SQL Server 2005
How do i find out what transaction log file was last applied to a database?

Answer Question   |  June 23, 2009  4:11 PM
Backup & recovery, SQL Server 2005, SQL Server backup, SQL Server transaction logs

SQL Server backup would not terminate
I tried to stop the backup which was already fired through job schedule,but it did’t stop. Then I stop the sql serveragent but it also not abled to stop the backup. The backup size was 100GB. Could you please give me the reason and solution of it.

Answer Question   |  March 26, 2009  10:58 AM
SQL Server Agent, SQL Server Agent Jobs, SQL Server backup

How to restore SQL Server 2000 backup file
how to restore sql 2000 backup file

Answer Question   |  March 2, 2009  5:58 AM
SQL Server 2000, SQL Server 2000 backup, SQL Server backup

Backing up virtual SQL servers
The following question was recently submitted by a user via e-mail: I’m using ArcServe to back up our virtual machines, and I’m wondering what other tools people are using to back up their virtual SQL servers?

Answer Question   |  March 23, 2009  3:14 PM
ArcServe, SQL Server backup, SQL Server backup and restore, Virtual SQL Servers

Taking a backup of a running site on a SQL Server
How can you take a backup of a running site on a SQL Server?

Answer Question   |  February 25, 2009  8:37 PM
SQL Server backup, SQL Server backup and restore

SQL Server data purging
I hv a trans tbl and want to keep the records to be purged on Tape/Media and read the data from there whenever required? I want to know, Is that possible to read data from the tape ? if so, then how to do it, neee help

Answer Question   |  February 24, 2009  5:36 AM
Backup & recovery, SQL Server, SQL Server backup, Tape Backups

SQL Server 2005 SP2 backup failing
This is my first post and thanks in advance for any replies. I have a backup that failed midway (about 120G of 230G) into the backup twice in the last 2 weeks. Each time, the first error that gets reported in the Application log has been, “BackupMedium::ReportIoError: write failure on backup device ‘\server_namedb_dump.bak’. Operating system [...]

Answer Question   |  February 23, 2009  7:54 PM
SQL Server 2005, SQL Server 2005 SP2, SQL Server backup, SQL Server backup and restore, SQL Server database

SQL Server 2008 Export data problem
Hi I’m trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy. Firstly I created a new empty [...]

Answer Question   |  February 19, 2009  1:43 PM
SQL Server 2008, SQL Server backup, SQL Server Data Storage, SQL Server Export

SQL Server 2005 backup
how to take backup of live site

Answer Question   |  February 16, 2009  11:32 AM
Backup, SQL Server 2005 backup, SQL Server backup

Trouble backing up our SQL Server transaction logs
Our SQL Server transaction logs have not been backing up, and I discovered it’s because a database was not selected in the maintenance plan. When I select the database and save it, however, it is not saving. It keeps reverting back to the previous option. Does anyone know why?

Answer Question   |  February 10, 2009  7:13 PM
SQL Server backup, SQL Server backup and restore, SQL Server transaction logs

Scheduling a Shrink Database in SQL Server 2000
Is there a way to schedule a shrink database after the transaction log has been backed up for a database via the maintenance plan?

Answer Question   |  February 3, 2009  4:41 PM
SQL Server 2000, SQL Server backup, SQL Server Shrink Database, SQL Server transaction logs

EMC Network Backup Client/Agent backup for SQL 2000/2005 databases on Polyserve Matrix
Hi, I am new with running SQL 2000/2005 instances on Polyserve Matrix servers. We use EMC Network as a corporate backup strategy. Can someone tell me will there be any problems using this backup tool for SQL instances on the Polyserve Matrix?

Answer Question   |  December 8, 2008  10:17 AM
Backup, EMC backup, HP PolyServe Matrix Server, PolyServe Matrix Server, SQL Server 2000, SQL Server 2000 backup, SQL Server 2005, SQL Server 2005 backup, SQL Server backup

Backing up and upgrading a SQL Server 2000 database
We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?

Answer Question   |  December 2, 2008  2:51 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server database, SQL Server upgrades