What about the query governor setting for queries? Should that be set? If so any recommendations?

Yes, The systems guy attached the drive from the previous server. When I installed I put the system databases on d: but the were already on F:/. I was...

No the restore never finished. It like it was just hung. There is no job running for it. I end up dropping and attempt to restore again...

I was concerned about low disk space. But it seems as if I need to watch to see if it stablize. Along with the database the log files grows...

Thanks this is definitely the route we're planning to go and usually the way I do it. Just needed some validation...

Restoring MSDB is this the 'norm' or just script the jobs and logins...? Can I have some advice on when to restore the Master and are you saying...

The bottom line is we trying to move a lot of databases. The approach we are taking is to take a copy of the databases and transfer them to another...

Also should I take the approach of detaching all user databases and restoring system databases? Is the efficient? Should I have any issues with different patches of sql server...

Thanks for the info. I guess i am looking for suggestions on Moving from one site to another and the best way to do it. We plan on...

What need to be script out and how to handle the master database and so forth. Moving from sql 2005 windows 2003 to Sql 2005 on windows 2008. The only...

Thanks. I'm moving from SQL 2005 to SQL 2005. The windows 2008 cluster is already built. Just move the drives or what to do with the master...

To piggyback on this same item...I restored and the database was left in loading state.  I ran the restore db with recovery in query analyzer and received the the error

(file...