jsb12 (2/16/2010)

---

sure, the reason for the custom log shipping is that theres no two way trust between domains. So we pull files by ftp from our domain which is trusted...

I cannot see a need for customised logshipping here. Just use the SQL supplied out of the box logshipping. Once the initial full backup is restored you don't have to...

glad it worked. I think you got slightly lucky in that this was a log file and the truncate_only happened to mean there were no active virtual logs in the...

welcome to the world of SQL2005 where DR is not as easy as it was...

check out the dbcc shrinkfile with emptyfile option and alter database (remove file) commands in BOL.

Back the database up before you start and do at a quite time.

sounds like a job for logshipping?

BTW Steve, thanks for highlighting that these SPs are in the pipeline.

I'll send the Overtime Bill to you 😀

Chris, if you are affected by issues that are fixed by CUs then you are right to apply the CUs, you just need to be aware CUs are not fully...

Yes, I have some decisions to make there. I have...

Hmm, I was never convinced about SP4 for SQL2005 seeing as SQL2005 SP3 is so stable (in my environment anyway). It will be interesting to see how microsoft word the...

Its normal for a restore to take 5-10% longer than a backup.

what sort of time difference are you seeing?

no probs.

If you want to reclaim the disk space used by msdb try the truncateonly option of dbcc shrinkfile first.

If you shrink the data file without truncateonly this will fragment...

run a reindex, backup again, see what happens

just to confirm, even after the delete, the backup is the same size?

Everything else being equal I would say you have no pressing need to upgrade now, EXCEPT

when SQL2008 R2 comes out in May there will be price increases of 15% for...