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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How can i have individual diff backup files

Author  Topic 

venkath
Posting Yak Master

202 Posts

Posted - 2006-10-11 : 07:06:09
Hi all

How can i have individual backup file each time the differential backup runs.

Thanks in advance..

nr
SQLTeam MVY

12543 Posts

Posted - 2006-10-11 : 07:28:02
see
http://www.nigelrivett.net/SQLAdmin/BackupDatabase.html
and
http://www.simple-talk.com/sql/backup-and-recovery/pop-rivetts-sql-server-faq-no2-pop-backs-up/

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-10-11 : 22:39:46
set a different name? usually concatenating the current date does the trick like dbname_Diff_10122006.bak

HTH

--------------------
keeping it simple...
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-10-13 : 05:53:55
"pop-rivetts-sql-server-faq-no2-pop-backs-up"

Great URL!

Is Pop your father then?! - and the brunt of some appalling jokes I suppose ...

Kristen
Go to Top of Page
   

- Advertisement -