it will still work.

If you have no SQL2000 change master.dbo.sysdatabases to master.sys.databases, and you could use the column recovery_model_desc rather than databasepropertyex, but either work.

The table names in msdb have...

this is a script I have based mine on when wanting similar information. SQL2000 compatible but still works on 2008.

that is correct.

as you have a principal and witness you still have a quorum so the principal can still service connections. However mirroring will be suspended. It will resume when...

As long as SQL is down when you do this and your databases end up on drives of the same letter when you restart, this will work. (I have done...

SQL will use a proportional fill algorithm across the data files (in the same filegroup) to try and keep the amount of free space in each file the same. If...

I don't know of a tool and I don't think there is one. If you enter 'build list' in the search bar on this site I will bring up a...

I avoid it as if I do I get asked to fix their PCs, and I know nothing about them. Trying to explain to the uninitiated that a DBA is...

are you clear on the steps?, what you suggested is ok.

phew, thank lord, thought it was just me

cheers.

Perry, can you confirm my post is visible please?

🙂

Ananda, if it is, see my post

no bother.

Its pretty simple and is available from SQL2008 on - just go to add\remove programs, make sure the 'show updates' check box is ticked, select SP3 and choose remove, (i...

to avoid this problem in the first place your backout plan should be to uninstall SP3, thus taking you back to SP1. there is no need to do a reinstall.

if you are seeing latch contention on the SGAM pages in tempdb (waitresource 2:1:3) just creating multiple files on the same disk will be enough to alleviate this.

checkdb and index rebuild are I/O intensive.