Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2006-08-16 : 14:56:27
|
| Hey All -I've been doing a lot of reasearch on backup strategies, what's the best approach to back up databases and etc.As I read on this forum, I saw that the most experienced folks around are avoiding the use of the maintenance plan, I already did that and just implemented Tara's maintenance sproc for full back up on a group of databases(http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx).Now, I didn't find any articles or sprocs to do a differential backup on the DBs, which kind of forces me to go back to Maint Plan.Is it really necessary to have a diff backup on the Full/Trasaction Log backup scenario ?Also, when do I want to delete backup history from msdb backup system tables ? Sorry, newbie on back up ;)---Thanks!Igor. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-16 : 15:00:21
|
I don't use differential backups. I run full backups nightly and transaction log backups every 15 minutes. I do have a newer version of the stored procedure mentioned in my blog that can do diffs, I just haven't posted the update yet. I run the delete backup history job every day. Here is a snippet of my new code:SET @fileName = @path + @dbName + '\' + @dbName + '_' + @now + @extensionIF @bkpType = 'FULL' BACKUP DATABASE @dbName TO DISK = @filename WITH INITELSE IF @bkpType = 'DIFF' BACKUP DATABASE @dbName TO DISK = @filename WITH INIT, DIFFERENTIALELSE BACKUP LOG @dbName TO DISK = @filename WITH INIT Tara Kizer |
 |
|
|
|
|
|
Differential Backups from TSQL