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
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
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
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
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
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
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
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
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 2000 backup file
Answer Question | March 2, 2009 5:58 AM
SQL Server 2000, SQL Server 2000 backup, SQL Server backup
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
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
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
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
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
how to take backup of live site
Answer Question | February 16, 2009 11:32 AM
Backup, SQL Server 2005 backup, SQL Server backup
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
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
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
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