Activity overview
Latest activity by mdolan
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...
Log shipping - Full or Bulk-Logged recovery model
I have log shipping across a WAN working now using the Full recovery model. I want to run DBCC REINDEX on my tables, but that will generate a huge amount of logging. I can switch to the Bulk-Loggin...
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...
GUI Refresh Problem
I have installed Pro 5.1.0.2781 on a Windows 2000 Standard server. The GUI never updates the Activity History or In Progress tab for the local server. The circular icon on the server connection jus...
Thank You.
I will gice it a try. / comments
Thank You.
I will gice it a try.
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 ...
Log Shipping on a WAN
We are moving a 8GB database from one location to another. I want to use log shipping across a WAN to keep the DB's sync'd.
I can send a full backup of the DB to the destination via an external HD ...