you don't want to be taking and restoring differential backups, you should be doing log backups.

with differential backups as soon as you take a full backup the differential resets and...

I would argue that if a server is there to support SQL, then the DBA should have full access to it. Servers that do not support SQL I have no...

The best practice for separating data and log files does not apply to system databases (tempdb excluded which can be on its own drive and is a special case)

the resource...

perhaps immediately updating subscribers or queued updating

http://msdn.microsoft.com/en-us/library/ms151718(SQL.90).aspx

pradyothana (5/18/2009)

---

I hope , If we are taking copy only back up on the primary server it wont break log shipping.

Full backup will change LSN so that next t-log...

? do not understand.

sorry, never personally had cause to use them.

But as your log shipping set up already exists you won't need to touch it, just disable LS jobs, restore the full backup...

just to confirm, if you have to restore a logshipped database to an earlier point in time you will have to re-initialise log shipping

Gail, stop it! give someone else a chance! 😀

sqlrumble (5/18/2009)

---

Hello,

This may sound like a silly question, but if a database has been moved to a new set of disks (SAN), would it be a good idea to rebuild...

select * from sys.databases where database_id > 4

pls see prev post, best I've got.

what error do you get?

I don't know any easy way

I think you need to look into the log_shipping_monitor_history_detail table and log_shipping_monitor_error_detail table in msdb.

there will be stored procs invoked when log shipping is removed,...

Are you getting 9002 errors in your errorlog saying log files are out of space? If not you might not have an actual problem (yet), you may have a full...