Comments
Sort by recent activity
Hello Jason,
The article from the book online was great. I forgot to mention that I'm working with SQL 2000, so I went into the SQL 2000 BOL and found a similar article on switching recovery models. http://msdn2.microsoft.com/en-us/librar ... 649(SQL.80).aspx
Thanks,
Matt / comments
Hello Jason,
The article from the book online was great. I forgot to mention that I'm working with SQL 2000, so I went into the SQL 2000 BOL and found a similar article on switching recovery models...
Hello Jason,
It only took 3 hours [image] after I changed the options to save/show 60 days of backup.
There is a problem though with letting it go that long. I have a command line log backup routine that runs across all 70 database on the server. It was blocked from running during the 3 hours. Maybe something else to pass along to the code geeks.
Regards,
Matt / comments
Hello Jason,
It only took 3 hours after I changed the options to save/show 60 days of backup.
There is a problem though with letting it go that long. I have a command line log backup routine tha...
Jason,
Do you have an estimate on "it can take a while to collate"? This SQL Server 2000 box has been running since 2002. It's been over an hour already and SQL Backup is grabing every cycle the SQL Server service isn't using. The box has been running at 100%.
Cheers,
Matt / comments
Jason,
Do you have an estimate on "it can take a while to collate"? This SQL Server 2000 box has been running since 2002. It's been over an hour already and SQL Backup is grabing every cycle the SQ...
I will give this a try on a smaller database and see how it goes.
One last question...
Once I start the log shipping, can I ever do a full backup on the source machine without throwing off the log sequence? If I do a full backup, do I have to do a full restore on the destination?
Thanks,
Matt / comments
I will give this a try on a smaller database and see how it goes.
One last question...
Once I start the log shipping, can I ever do a full backup on the source machine without throwing off the log ...
Thank You.
I will gice it a try. / comments
Thank You.
I will gice it a try.