Ed Dee (11/3/2009)

---

Overall any backup and recovery is complicated in complicated cases - but many cases are not complicated and the GUI interface despised by some is generally easy to...

there is no way to change the thresholds just for the time the reindex is running. At least you know why the threshold is being breached.

Krishna is on the right...

Its a personal choice. As hourly is quite a low frequency I would go for just over twice the backup frequency.

Log backups can occur whilst indexes are rebuilt, in fact it is more important that they do as reindex can produce a lot of log.

Is your log backup frequency...

Thats good to know. Pure coincidence I logged into active threads and this came up top of the list!

🙂

I don't think it is complicated. SSMS will build up a restore job for you starting from the latest full backup to the latest tran log backup. all the information...

SQL server service needs to be running under a domain user account and that account needs read permissions on the share.

Is this log shipping created via the wizard because there should be an option to delete the .trn files older than a specified age.

Its the restore job that deletes them...

SELECT DATEADD(hh, 13, getdate())

Mark_Pratt (10/31/2009)

---

Sounds like schoolboy error from MS! Perhaps they should have used where sid = 0x01 and...

just a warning to those guys who have renamed the 'sa' account

http://support.microsoft.com/kb/960781

campag or shimano mr brew?

If it helps allay your fears you can log ship to a database of a different name, so you could have them all in one instance.

the external expert is probably...

I have installed MS09-062 on one server (2005 SP4 9.00.4035). It installed and updated all components on server (database engine, SSIS,SSAS,SSRS) but as RS was installed does not answer the...

with SQL 2005 I would be careful about restoring the msdb database to a different server. In SQL 2000 this was a doddle you just updated the sysjobs.originating_server column to...