Yes that should work.  But sometimes I want to use the GUI to right click and restore, but this never seems to work even after putting the database in single...

I had already set the database to single user mode.  alter database xxx set single_user       so there shouldn't be anyone connected.

Mike, I agree and I'm finally getting my CIO's support for local admin rights on sql boxes -- our chief network admin still seems cool to this idea but is...

I'm going to take a slightly different approach in my comment here. Yes these are great utilities.  What I would like to know is how many people acting as DBAs...

Mirroring requires sql server 2005 service pack I to be used in production.  You mentioned the comprehensive article at the link below. 

 " no more than 2-5 seconds latency "  I...

There is an approach in Books on Line for sql 2005, listed at the bottom of the article on sys.dm_db_index_physical_stats. 

This approach, which can be adapted to a stored...

I currently telecommute half a day Tues-Fri and all day Saturday.  The main problem I have is that too many co-workers are email challenged.  We are an IT company but...

Our network administrator was trying to do the install and failed. It may be that he tried to use the same name for our existing sql 2000 virtual server.  I...

RE: Upgrading active/passive SQL 2000 cluster to SQL 2005:

I'd like to hear more input/experiences with this type of upgrade. We wanted to upgrade SQL 2k Enterprise on our cluster...

Open the sql server management studio and connect to your database.  Find the "management" section and open that up.  You will see maintenance plans, right click and select the wizard.  ...

I really didn't want to start up the old arguments about dynamic sql versus procs.  Yes, the dynamic sql we're using now is automatically generated, not embedded in code or...

Check out log shipping under sql server 2005 Books Online -- doesn't appear to me that log shipping can work between two different versions of sql server.

"You cannot directly upgrade...

Thanks for your response.  The part about long field names affecting performance is interesting -- hadn't heard that before.  This reminds me of a feeling I've had for a long...

I didn't want to risk putting the database in simple mode or single user mode at night.  I was concerned that it might not automtically make it back to multi...

One more thing.  In either a real outage of the primary, or in DR testing I want the best tsql commands to get the standby out of standby for use,...