SQL Server 2005 Full/Differential Backup Issues
Jun 29, 2007
Hi,
After some advice - I have a SQL Server 2005 database which is part
of an anti-virus setup. The main database is 25Gb is size, and it
is running in simple recovery mode. There are two backup jobs in
place, one to do a differential backup each Mon-Sat, and one to
do a full backup on Sun. Although the backups do get done they
are taking 5 hours to do. Any wiz out there care to suggest what
the problem is, I would've though that maybe an hour was more
acceptable ?
Cheers,
Gordon
View 2 Replies
ADVERTISEMENT
Sep 11, 2007
I want to set a full and differential backup to one database in sql server 2000.
Is there a way to set both full and differential to just one database.
i want the full backup weekly once and differential every day to set up.
Please let me know
View 3 Replies
View Related
Feb 19, 2015
Using Ola Hallengren's scripts I do a full backup of a database on a Sunday. Then differential backups every 6 hours and log backups every hour. I would like to keep a full week of backups based off the full backup done on Sunday. Is there a way for me to clear out the diff and log folders after the successful full backup on Sunday nights?
View 2 Replies
View Related
Nov 16, 2015
I have a database that is just over 1.5GB and the Full backup that is 13GB not sure how this is since we have compression on for full backups and my other full backups are much smaller than there respective databases...Now my full backup is taken every Sunday night and the differentials are taken every 6 hours after the full backup. Now I have been thrown into this DBA role with little to no experience just what I have picked up and read. So my understanding of backups are limited but what I think I understand is that we take a full backup and the differential only captures what changes in the database so my question is why is my database 1.5GB but my differential is 15.4GB? I have others database that are on the same instance and don't seem to have this problem. I also just noticed that we do not rebuild the index before a full backup like we do on other instances...
View 13 Replies
View Related
Jul 19, 2007
Hi
I am using the Simple recovery model and I'm taking a weekly full backup each Monday morning with differentials taken every 4 hours during the day.
On Wednesday afternoon, a programmer ran a process that corrupted the db and I had to restore to the most recent differential. It was 5pm in the afternoon and a differential backup had just occured at 4pm. No problem, I figured.
I restored the full backup from Monday morning and tried to restore the most recent differential backup. The differential restore failed. Since I had used T-SQL for the initial attempt, I tried using Enterprise Manager to try again.
When viewing the backup history, I see my initial full backup taken on Monday plus all the differentials. BUT, on closer inspection, I noticed another full backup in the backup history that was taken early Tuesday morning. I can't figure out where this Tuesday morning full backup came from. It wasn't taken by me (or scheduled by me) and I'm the only one with access to the server. My full backups are usually named something like HCMPRP_20070718_FULL.bak. This erroneous full backup was named something like HCMPRP_03a_361adk2k_dd53.bak. It seemed like it was a system generated name. Not something I would choose. To top it off, I could not find this backup file anywhere on the server and when I tried to restore using this full backup, it failed.
Does anyone have any clues as to where this full backup might come from? Does SQL Server trigger a full backup on its own if some threshold is reached?
I ended up having to restore using the differential taken just before this erroneous full backup and lost a day of transactions.
Any insight is greatly appreciated.
View 3 Replies
View Related
Jun 6, 2007
Hi,
Using SQL Server 2005, we have a 2.8Gb database under the Simple recovery model. The database contains ~50M rows and each night ~60k rows are loaded(appended) to the database by a SSIS task.
We configured a Maintenance Plan which is executed once a week to perform a full backup of the database. The resulting backup file is ~2.8Gb, as expected.
We also configured another Maintenance Plan which is executed every day, a few hours after the SSIS task is executed, to perform a differential backup. To our surprise, the resulting backup file is about the same size as the full backup, ~2.8Gb when it should only be a few MB (only 60k rows are added to the database)
When we launch the "Restore Database" wizzard we clearly see the different backup set, Full and Differential but they all have about the same size (same for the physical backup file on disk).
Is there anything we are missing, why are the differential backup that big?
Thanks for any advice.
View 4 Replies
View Related
Sep 13, 2006
I am running the following script to attempt a restore of a differential backup:
RESTORE DATABASE AdventureWorks
FROM DISK='C:SQL2005_BackupsAutoBackupsAdventureWorks.bak'
WITH
NORECOVERY
GO
RESTORE DATABASE AdventureWorks
FROM DISK='C:SQL2005_BackupsAutoBackupsAdventureWorksDiff.bak'
WITH RECOVERY
GO
I thought this was the way to do it. It does restore the full backup, but on the attempt to restore the differential backup, I get the following error:
Msg 3136, Level 16, State 1, Line 1
This differential backup cannot be restored because the database has not been restored to the correct earlier state.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Does anyone know what this means? Do I have to use "with recovery" on the first restore? (The sample I took this from used "with norecovery")
The original backups were done with SQL Agent scheduled jobs. The script for the full backup is:
BACKUP DATABASE AdventureWorks
TO DISK='C:SQL2005_BackupsAutoBackupsAdventureWorks.bak'
The script for the differential backup is:
BACKUP DATABASE AdventureWorks
TO DISK='C:SQL2005_BackupsAutoBackupsAdventureWorksDiff.bak'
WITH DIFFERENTIAL, INIT
All I can say is, it's a good thing I am testing this out with non-critical data, because I obviously don't know what I am doing. (Sorry, I'm primarily a programmer, not a DBA) Can anyone help?
Thanks
View 4 Replies
View Related
Apr 4, 2007
We have a script that I had to rework a little bit for 2005 that doesa full backup for every database on the server... For some reason onsome nights the script does not backup all databases... Its like itskips over it for some reason... Output of the script below on thenight in question was:Executed as user: NT AUTHORITYSYSTEM. master [SQLSTATE 01000](Message 0) Status is ONLINE dbname / dbdevice = master / SQLBUmaster[SQLSTATE 01000] (Message 0) Processed 376 pages for database'master', file 'master' on file 1. [SQLSTATE 01000] (Message 4035)Processed 2 pages for database 'master', file 'mastlog' on file 1.[SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfullyprocessed 378 pages in 0.169 seconds (18.298 MB/sec). [SQLSTATE 01000](Message 3014). The step succeeded.A normal night on this particular server includes two other databaseslike below:(Message 0) Processed 376 pages for database 'master', file 'master'on file 1. [SQLSTATE 01000] (Message 4035) Processed 2 pages fordatabase 'master', file 'mastlog' on file 1. [SQLSTATE 01000] (Message4035) BACKUP DATABASE successfully processed 378 pages in 0.711seconds (4.349 MB/sec). [SQLSTATE 01000] (Message 3014) msdb[SQLSTATE 01000] (Message 0) Status is ONLINE dbname / dbdevice =msdb / SQLBUmsdb [SQLSTATE 01000] (Message 0) Processed 688 pages fordatabase 'msdb', file 'MSDBData' on file 1. [SQLSTATE 01000] (Message4035) Processed 5 pages for database 'msdb', file 'MSDBLog' on file1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfullyprocessed 693 pages in 3.743 seconds (1.516 MB/sec). [SQLSTATE 01000](Message 3014) SBC [SQLSTATE 01000] (Message 0) Status is ONLINEdbname / dbdevice = SBC / SQLBUSBC [SQLSTATE 01000] (Message 0)Processed 11577184 pages for... The step succeeded.The script is schedule to be run nightly and it looks like this:ALTER PROCEDURE [dbo].[usp_backupFull] ASset nocount onDeclare @start_time datetime,@end_time datetime,@backupsize real,@status varchar(100),@cmd nvarchar(255),@monitor_server varchar(50),@recovery varchar(100),@db_name varchar(100),@dev varchar(100),@logvarchar(100),@backup_folder varchar(100),@dev_path varchar(255),@log_pathvarchar(255),@message_text varchar(255),@subject_text varchar(255),@error varchar(50)Select @backup_folder ='D:SQLBU'--Select @monitor_server ='MONITOR'CREATE TABLE #error (dbname varchar(50), error varchar(50))DECLARE db_cursor CURSOR FOR SELECT name FROM master..sysdatabaseswhere name not in ('Northwind','pubs','tempdb','model')OPEN db_cursorFETCH NEXT FROM db_cursor INTO @db_nameWHILE @@FETCH_STATUS = 0 BEGINSELECT @dev = 'SQLBU' + @db_nameSELECT @dev_path = @backup_folder + @dev + '.bak'SELECT @log = 'SQLBU' + @db_name + 'LOG'SELECT @log_path = @backup_folder + @dev + '_log.bak'PRINT ''PRINT @db_namePRINT ''IF NOT EXISTS (SELECT name FROM master..sysdevices where status=16and name=@dev) BEGIN-- Create new backup device if it doesn't existEXEC sp_addumpdevice@devtype='Disk',@logicalname=@dev,@physicalname=@d ev_pathPRINT ''ENDSelect @recovery =CONVERT(varchar(100),DATABASEPROPERTYEX(@db_name,' Recovery'))IF @recovery <'SIMPLE' BEGINIF NOT EXISTS (SELECT name FROM master..sysdevices where status=16and name=@log) BEGIN-- Create log backup device if it doesn't exist and logging not setto SIMPLEEXEC sp_addumpdevice@devtype='Disk',@logicalname=@log,@physicalname=@l og_pathENDENDSELECT @status = CONVERT(VARCHAR(100),DATABASEPROPERTYEX(@db_name,'Status'))print 'Status is ' + @status + ' dbname / dbdevice = ' + @db_name +' / ' + @devIF @status = 'ONLINE' BEGINSELECT @cmd = 'BACKUP DATABASE ' + @db_name + ' TO ' + @dev + ' WITHINIT'EXEC(@cmd)IF @@ERROR <0 BEGININSERT INTO #error VALUES (@db_name,'Full backup Failed-Check Log')--Select @cmd = 'osql -U srvMonitor -P backups -S ' +@monitor_server + ' -d Monitor -Q "insert into backups([date],server_name,db_name,backup_type,status) values (GETDATE(),'''+@@servername +''',''' + @db_name + ''',''Full'',''Failed'')"'--Execute master..xp_cmdshell @cmdENDELSE BEGINSELECT @start_time = backup_start_date, @end_time =backup_finish_date, @backupsize = (backup_size / 1024 / 1024) FROMmsdb..backupset WHERE (type = 'd') AND (database_name = @db_name) AND(backup_finish_date DATEADD(mi, -1, GETDATE()))--Select @cmd = 'osql -U srvMonitor -P backups -S ' +@monitor_server + ' -d Monitor -Q "insert into backups values(GETDATE(),'''+ @@servername +''',''' + @db_name +''',''Full'',''Success'',''' + cast(@start_time as varchar(50)) +''',''' + cast(@end_time as varchar(50)) + ''',' + cast(@backupsize asvarchar(50)) + ')"'--Execute master..xp_cmdshell @cmdENDPRINT ''SELECT @recovery =CONVERT(VARCHAR(100),DATABASEPROPERTY(@db_name,'Is TruncLog'))IF @recovery <'1' BEGINSELECT @cmd='BACKUP LOG '+@db_name+' TO ' + @log + ' WITH INIT'EXEC(@cmd)IF @@ERROR<>0 BEGININSERT INTO #error VALUES (@db_name,'Log backup Failed-Check Log')--Select @cmd = 'osql -U srvMonitor -P backups -S ' +@monitor_server + ' -d Monitor -Q "insert intobackups([date],server_name,db_name,backup_type,status) values(GETDATE(),'''+ @@servername +''',''' + @db_name +''',''Log'',''Failed'')"'--Execute master..xp_cmdshell @cmdENDELSE BEGINSELECT @start_time = backup_start_date,@end_time=backup_finish_date, @backupsize = (backup_size / 1024 / 1024) FROMmsdb..backupset WHERE (type = 'L') AND (database_name = @db_name) AND(backup_finish_date DATEADD(mi, -1, GETDATE()))--SELECT @cmd = 'osql -U srvMonitor -P backups -S ' +@monitor_server + ' -d Monitor -Q "insert into backups values(GETDATE(),'''+ @@servername +''',''' + @db_name +''',''Log'',''Success'',''' + cast(@start_time as varchar(50)) +''',''' + cast(@end_time as varchar(50)) + ''',' + cast(@backupsize asvarchar(50)) + ')"'--Execute master..xp_cmdshell @cmdENDENDPRINT ''ENDELSE BEGINPRINT 'The database was not backed up due to options that were setunder sp_dboptions'PRINT ''INSERT INTO #error VALUES (@db_name,'DB Not backed up due to DBoptions')--Select @cmd = 'osql -U srvMonitor -P backups -S ' +@monitor_server + ' -d Monitor -Q "insert into backups([date],server_name,db_name,backup_type,status) values (GETDATE(),'''+@@servername +''',''' + @db_name + ''',''Full'',''Not Backed up -Check DB Options'')"'--Execute master..xp_cmdshell @cmdENDFETCH NEXT FROM db_cursor into @db_nameEND--WHILE-- Open error cursor --DECLARE db_error CURSOR FOR SELECT dbname,error from #errorOPEN db_errorFETCH NEXT FROM db_error into @db_name,@errorWHILE @@FETCH_STATUS = 0 BEGINSELECT @message_text = @error + ' for ' + @db_nameSELECT @subject_text = '!!!!!! ' + @@servername + ' - Backupfailed for ' + @db_name + ' !!!!!!'--exec msdb..usp_Alerts @mess = @message_text ,@subj=@subject_textFETCH NEXT FROM db_error into @db_name,@errorEND --WHILEDROP TABLE #errorPRINT ''DEALLOCATE db_cursorDEALLOCATE db_errorset nocount off---------------------------------------------------------------Any help I would appreciate it... As you can see from the output aboveit looks like its not even getting the database name to backup in thecursor. But that just doesn't make any sense to me... why could thatbe.
View 2 Replies
View Related
Jun 14, 2000
Hello,
I'm trying to run a differential backup on our new 7.0 box. It fails with an error message number 3242 "The file on Device 'E:MyFile' is not a valid Microsoft Tape Format backup set."
Why "Tape Format" if I said "Backup database [mydb] to disk"?..
When I run exactly the same query without "Differential" I got a full db backup.
Am I doing something wrong?
Thank you,
Anastasia.
View 1 Replies
View Related
Feb 10, 2015
Look at this scenario
1- I have created a backup device
2- I have created a maintenance plan full backup and run it - with overwrite option on the backup device
3- I have created a maintenance plan differential backup and run it with append option on the same file of backup device
4- I have created a maintenance plan log backup with append option on the same backup device
When I made restore database from the backup device i found three files the full and differential and log backup
5- I ran again the differential backup maintenance plan ( suppose to be ran everyday night )
when i made restore database I found only two backups the full and the last differential !!!
what I want to do is to take a full backup every week , append differential backup everyday and append log backup every hour
when I ran the last differential backup it erased the first differential and log backups, why is this happening and how to apply this scenario and keep the all differential backups on the same backup device .
View 4 Replies
View Related
Feb 25, 2015
We have a 1TB Database. Our backup strategy looks like this.
Weekly Full backups - Saturday 10pm. (Takes anywhere between 5 - 9 hours)
twice Nightly Diffs (8:30p and 2:30am - Mid week this takes roughly 1.5 hours)
Hourly Log backups starting at 4:00am until 11pm.
I have an issue where I need to restore to 3:00 today. If my (2:30a)Diff is still running at that recovery point.
I am getting an error when trying to restore Full/2:30a Diff/4a Log with a stopat 3:00a.
Error telling me my log backup is incorrectly formed.
Can I, in fact, restore to this point at all? Do I need to go back to my previous Diff (8:30p) and restore the logs, if so, which ones?
My nighttime Diff ran from 8:30 - 10p.
I have logs at 9p, 10p, 11p, 4a
View 8 Replies
View Related
Aug 17, 2007
I have done a full backup on 3pm, and a differential backup on everyday 5pm.
I try to restore it back in my testing server and i encounter the problem in restoring the File3 and i try to restore the File 2 and it is okie. Can i know wat is the problem usually cause this error? Thank you
File 1: Full Backup
File 2: Differential Backup
File 3: Differential Backup
View 10 Replies
View Related
Jan 11, 2001
PLEASE HELP...
WE ARE DOWNLOADING THE BACKUP FILE FROM OTHER BRANCH OFFICE AND THE FILE SIZE IS GROWING LIKE HELL SO I AM CHANGING THE BACKUP POLICY TO DOWNLOAD THE DIFFERENTIAL BACKUP FILES EVERYDAY. BUT EVEN THE FILE SIZE GROWS DAY BY DAY UNTILL WE TAKE THE FULL BACKUP THERE. SO I WANT TO TAKE A DIIFERNETIAL BACKUP AND THEN IMMIDIATELY A FULL BACKUP AT THE REMOTE SERVER END. SO MY NEXT DIFFERNTIAL BACKUP WILL HAVE THE DATA OF ONLY PREVIOUS DAY.
FOR THIS I AM SCHEDULING A JOB WHICH FIRST TAKES A DIFFERENTIAL BACKUP AND THEN IMMIDIATELY FULL BACKUP EVERYDAY AT 12.00AM.
BUT I HAVE A CONCERN.. WHILE TAKING THE DIFFERENTIAL BACKUP ANY TRANSACTIONS THAT ARE TO BE COMMITED WILL NOT COMMIT UNTIL THE DIFFERENTIAL BACKUP COMPLETES. BUT IMMIDIATELY I AM STARTING FULL BACKUP. IS THERE ANY CHANCE THAT A TRANSACTION GETTING COMMITTED IN BETWEEN THESE TWO STEPS. IF SO IS THERE ANY WAY .. NOT RELEASE THE DATABASE UNTILL THESE 2 BACKUPS ARE COMPLETED?? I AM RUNNING IT AS A JOB..
ANY SUGGESTION??
THANKS IN ADVANCE.. :-)
KUMAR
View 2 Replies
View Related
Mar 28, 2007
Does the full and differential backups have to be in the same location or can I do a once a week full backup on one drive and everyday differential backups on a different drive?
Thanks
View 4 Replies
View Related
Aug 28, 2007
Hi All,
I am trying to restore full backup in Sql Server 2005. I am using the following query to restore full backup.
"Restore database Testdb from Disk = 'C:Testdbfull.bak'
with move 'Testdb' to 'C:DBTestdb.mdf ',
move 'Testdb_log' to 'C:DBTestdb_log.ldf ', norecovery "
The above query is running successfully and database restored. But i am not able to access this database since in the database tab it is showing 'Testdb (Restoring)'
The next day I want to restore the differential database backup so i used the 'norecovery' statement.
please help why it is showing as '(Restoring)'
Thanks in advance,
Senthil
View 21 Replies
View Related
Mar 29, 1999
Hi
Is there anyway I can implement a standby server in SQL Server 6.5 ? In addition are there any tools in the market which I can use to perform a differential backup ?
I believe SQL Server 7.0 can do this, will I be able to use ARCserverIT or seagates's backup exec to perform these functions ?
Vijay
View 1 Replies
View Related
Jun 13, 2007
what is the differences between a differenctial backup and transaction log backup?
View 1 Replies
View Related
May 12, 2008
Hi sql server experts.
This is a beginners question.
Let's say, I run a full backup at 4:30 am it takes usually 35 minutes to finish.
I want to schedule a differential backup to run every hour.
Should I start this job at 5:10 after the full backup finishes? or it doesn't matter?
I am confused about timing.
Let's say my full back up takes 1 hour to finish, that means that when the differential backup runs the full backup will be still running, so in case I need to restore the database, can I use this differential from 5:10 or the differential from 6:10.
Same issue with the transactional, the job runs every 30 minutes, should I started after the differential is done?
I am so confused, what happens with the backups jobs that run while other backups are running?
Is this something that should never happen.
Please advise.
Thanks
View 8 Replies
View Related
Aug 3, 2015
Need to restore database,here's the scenario:
Data got deleted on Friday evening, need to have database restored to FRiday afternoon and also some data has been entered on Monday, which needs to be there.
View 8 Replies
View Related
Jul 23, 2005
My company needs to move a 30 Gig SQL Server across the country as soonas possble on July 1. Turns out moving the full db across the networktakes a few hours.I'd like to move a full copy of db a week ahead of time, and then justmove either a differential backup(s) or transaction log with with theweek's new data on July 1.Can anyone suggest the best strategy for doing this? Currently we'redoing a differential backup each hour on the db, and dumping the txnlog each night.Many thanks,Burt
View 1 Replies
View Related
May 3, 2001
SQL 7.0 SP1 on NT 4.0 EE
Thru maintenance plan I backup my DBs every night and the T-Logs every hour.
Now I have to set the option "select into/bulk copy" on one DB.
I schedule the differential backup every 3 hour with option "overwrite existing media", wich is, in my case, one file on disk.
My sequence of T-Logs is valid even if a non logged operations occurs?
If I have to restore this DB can I use the last full backup + the differential backup + all the logs in between?
example:
22.00 full db backup
08.00 t-log
09.00 t-log
10.00 t-log
10.30 diff backup
11.00 t-log
12.00 t-log
13.30 diff backup
14.00 t-log
15.00 t-log
Or my log are unusuable because the non logged operation?
Thank you very much.
View 4 Replies
View Related
Aug 31, 2001
I trying to created a Differential backup and I get the following error. Can anyone help?
The volume on device 'd:MSSQL7BACKUPCPIDATABKUP.BAK' is not part of a multifamily (RAID) media set. Use WITH FORMAT to form a new RAID set. [SQLSTATE 42000] (Error 3259) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Thanks
View 1 Replies
View Related
Sep 19, 2001
I'm trying to create a differential backup job that run hourly and that creates a different differential files. Ext. dbfilename1am, dbfilename2am, dbfilename3am ect... Can I do this with one job? Are do I have to create a differential backup job for each hour?
Thanks
View 1 Replies
View Related
May 18, 2008
Hi,
I've defined a maintenance plan in SQL2005, which creates a differential backup of a DB daily. Suppose I'm having differential backups from May, 10 to May, 14 but backup files of May 12 and May 13 are lost (deleted unexpectedly). Am I losing some data, if I restore from backup file of May 14?
Thanks & Regards,
View 5 Replies
View Related
Sep 17, 2001
I need to replication a server database out side a firewall. But can't change the server configuring for replication, so replication is out. So I wanted to know if I have a full backup of every db send to me every 24hrs. W/ differential every hr, will the restoring process work on the restoring server? Should I restored the full 1st? I'm not sure if the restoring of the Differential will work. Any help on the steps to take, to get this to work with backups & differential will be greatly appreciated.
Thanks Reggie
View 1 Replies
View Related
May 16, 2013
Differential back up failed , verify the network error 51
View 2 Replies
View Related
Feb 4, 2004
When a new scheduled job is created for a Differential backup, the file specified in the Destination folder is automatically created by SQL Server. After the first time the job runs, is there a way to configure SQL Server to give each Differential file a unique name, including the timestamp (i.e. similar to Full Backup jobs)? I noticed my only options are 'Append to File" and "Overwrite Existing File." If I choose to enable "Backup Set Expiration," the backup job will not run, because it wants to append/overwrite the filename specified.
View 1 Replies
View Related
Nov 13, 2007
Hi Guys I need a samll help to create bat file for differential backup
SQL IN Minds
View 4 Replies
View Related
Nov 13, 2007
Hi Guys I need a samll help to create bat file for differential backup
SQL IN Minds
View 2 Replies
View Related
Feb 9, 2008
Hi,
Im trying to restore the differential backup,I have to restore the full backup first and then restore the differential backup.Can any body tell me the code for this?
my program is like this
--for fullbackup
if type=D
begin
restore database databasename
from disk=path
end
--for differential backup
else if type=I
???
View 15 Replies
View Related
Jul 20, 2005
I have recently started receiving failures on a differential backup thatpreviously succeeded. Nothing has changed with the structure of the db.Here is the message, any ideas are welcomed. Thanks.Executed as user: fsafood-netisqlservice. The backup data in'E:SQL_BackupsBiz_SalesBiz_Sales_Diff.bak' is incorrectly formatted.Backups cannot be appended, but existing backup sets may still beusable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminatingabnormally. [SQLSTATE 42000] (Error 3013) Associated statement is notprepared [SQLSTATE HY007] (Error 0) The media family on device'E:SQL_BackupsBiz_SalesBiz_Sales_Diff.bak' is incorrectly formed. SQLServer cannot process this media family. [SQLSTATE 42000] (Error 3241)VERIFY DATABASE is terminating abnormally. [SQLSTATE 42000] (Error3013). The step failed.*** Sent via Devdex http://www.devdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Oct 8, 2006
I create a full backup followed by daily differential backup, when I restore database from the fifth or later differential item, I get the following Error Message:
System.Data.SqlClient.SqlError: This differential backup cannot be restored because the database has not been restored to the earlier state. (Microsoft.SqlServer.Smo)
It seems that there is an error when the fifth differential backup occurred, It's a disaster, how can I do, help!
View 6 Replies
View Related
Mar 26, 2008
Where can I find more about Multibase Differential Backups? I searched through BOL and MSDN (http://msdn2.microsoft.com/en-us/library/ms178046.aspx) but there is too few information (missing sample, backup syntax for selecting differential base).
Is it possible to have two (or more) bases for differential backup for one database?
How to preform such backups?
View 5 Replies
View Related
