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 |
|
mparter
Yak Posting Veteran
86 Posts |
 Posted - 2005-08-22 : 11:01:22
|
| I've setup a Database Maintenance Plan (DBM) in SQL EM to log ship a database to 2 servers. In this DBM, I've set it to delete tlogs older than 1 week.It now appears that I can't recover to a point-in-time as obviously these older tlogs are missing. With this being the case, should I be performing a full database backup every x days as part of the DBM? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-22 : 12:58:33
|
| Yes! That's the only way to restore. You need to start with some full backup and the entire transaction log chain up to the point of failure. We perform full backups daily and transaction log backups every 15 minutes. And this is setup in the log shipping maintenance plan.Tara |
 |
|
|
mparter
Yak Posting Veteran
86 Posts |
Posted - 2005-08-22 : 15:22:22
|
| So that's where I/we've been going wrong. Thanks, I'll adjust the maintenance plans ASAP. |
|
|
|
mparter
Yak Posting Veteran
86 Posts |
Posted - 2005-08-22 : 18:18:35
|
| Another quick question(s)!You say I need to take a full backup, and this can be done via the Maintenance Plan. How? I know there's a form for specifying backing-up the database but this only backs the database up to the local server, which kinda defeats the purpose of log shipping. How do I set it up to "ship" the database backup to the same location as my tlogs? Or do I have this all wrong?What's the best way to recover? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-25 : 12:26:41
|
| Log shipping will not copy the full backup over to the destination server. We have another job that does this with xcopy.Tara |
|
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-08-25 : 12:46:16
|
quote:
Originally posted by tduggan
Log shipping will not copy the full backup over to the destination server. We have another job that does this with xcopy.Tara
What makes XCOPY better than COPY?DanielSQL Server DBAwww.dallasteam.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-25 : 12:58:15
|
| Run xcopy /? and copy /? from a cmd window to check them out. xcopy has way more options.Tara |
|
|
|
|
|
|
Log Shipping Confusion