When SQL Server wants to expand any file, log or database, the operation can fail if the increment size is smaller than the space SQL needs to complete the active...

You should remove the -T3608 parameter when you are finished moving the system databases.  You will have to restart SQL after removing the parameter, as it affects the way SQL...

You should move Master via the SQL startup parameters.  Never try to detach Master, because if somehow it does succeed you will never get it back.

TempDB should only be moved...

It is not SQL that is taking the lock, it is the tape backup process.

If the success of tape backups is not properly checked, a failed backup may not get detected...

I have recently tried defragging a W2003 test server running SQL2K SP3a, while SQL was active and using the defrag tool supplied with W2003.

It worked.

Even so, I would not want...

Jeff,

The key to this has already been posted.  The ability to stop/start SQL Agent has nothing whatsoever to do with internal SQL Server authorities.  It is purely a NT...

My experience of Windows Defrag is that it needs the same amount of free space as the largest fragmented file if that file is to be defragmented.

You get a warning...

If your clients are on a WAN, ensure that the port used by the named instance is not blocked by firewalls.  Firewall blocking may not inhibit registration, but it would...

Are there any cirsumstances where 2 GUIDS could be created with the same value?

If one of the factors in GUID creation is time, then the granularity of the time factor...

There is a problem on SQL2000 SP3 documented in KB815115 A DTS Package That Uses Global Variables Ignores Error Message Raised by RAISERROR.  A fix is available on...

If you are talking about how to prevent SQL System Administrators from access databases, you can NOT do this.  Some other DBMSs allow access by system admins to be prevented,...

Cool !!!

I will have a go at some of the questions...

a) You should always go for a 3NF design at the logical design stage.  Until you have a 3NF design, you...

In most organisations, MCDBA is unlikely to improve your salary or career path on its own.  You need to show by your actions you are worth paying more.

In job hunting,...

Why are you not using NT only security.  We do this on all our servers bar 1.  The odd one is running some legacy web-based applications that require SQL authentication.

NT...