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 |
|
femig
Starting Member
5 Posts |
 Posted - 2004-06-24 : 13:07:09
|
| what i want to achieve is this;1) i take full bkps every sunday2) differential bkps every nite3) log bkps every hour4) i want to be able to restore the db to the closest point in time possible..5) my recovery model is full6) i want to keep my log files as small as possible by truncating them using bkps..will this log bkp code achieve this;BACKUP LOG [adp2sql] TO [xxxBackup] WITH NOINIT , NOUNLOAD , NAME = N'xxx_log_bkp', NOSKIP , STATS = 10, NOFORMAT thanks for ur patience..i need to get this right |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-24 : 13:10:57
|
| I don't ever use WITH NOINIT (I use WITH INIT). I create new files each time. I put a timestamp in the filename so that it is unique and doesn't overwrite an existing file. What you have will allow you to restore to a point in time. You will eventually need to use WITH INIT as adp2sql is going to keep on growing and growing and growing. Check out my weblog for some stored procedures to do the full backups and transaction logs with a unique filename:http://weblogs.sqlteam.com/taradTara |
 |
|
|
|
|
|
keeping log file size low after backups