Please be aware that setting your DB to simple and back to full again will break your log chain and you must take a full backup to start it over.

See this post on SQLServerCentral;

http://www.sqlservercentral.com/Forums/Topic646091-146-1.aspx#bm648916

I posted my "Post Installation Steps" doc on it.

It's not all inclusive, but a good start.

Also, make sure the "Browser" service is started in SQL Config Mgr. By default, you can connect to a default (machine name only) instance using port 1433. However,...

After I've analyzed my disk layout, server size, etc... and installed SQL 2005 with the latest SP. I then use the attached doc.... this should be a...

make sure you install "Developer Edition" on the development server. Developer Edition is full blown EE but only costs $50 bucks (last I checked).

It might be a good idea to clear up the difference here and I will defer to Gail's expertise.

However, this is what I was referring to:

http://msdn.microsoft.com/en-us/library/ms187054.aspx

"If...

On the "Advanced Options" of the installation, if you highklight the "DataBase Services" line at the top, clisk "browse" at the bottom and this will change the location of the...

I'd like to just add that only changed pages get read from the Snapshot. Non-Changed pages still get read from the original database.

Also, if you make the cluster active-active...

do not use truncate log. That will break your log chain and require you to do an immediate full backup. I've never tried to shrink a log file...

Have you shrunk your tran log file down to a normal opertaing size?

I'm not sure why you're so concerend about the system database .mdf and .ldf files being on different drives. It's perfectly normal to have them all together. ...

I'm not sure why you are reorg'ing ALL indexes and then rebuilding ALL indexes. The reorg will move pages around, but then the rebuild totally wipes out your indexes...

I liked "EDI" in the movie Stealth. hit by lightning, rogue computer gone bad, then good at the end. And he was a new Talon military aircraft. ...

you can only rename the machine name part of a named instance. ie. machine\instancename. (or if it's a default instance, you can rename that). You...

sp_help_revlogin sp's attached....