This subject is a little bit outside of my experience, but we are trying to upgrade our server. We have a new machine, but are using the same versions of the servers on it (MS Server 2003, and SQL Server 2005).
On our first attempt, we had problems with the new server randomly dropping the user connections, so we reverted to the old server. The boss thinks he has that worked out, but we had another problem concerniong moving the databases that is bugging us.
To move the databases over, we detached them from the old server, and copied the data files and the log files to the new server and reattached them there. Everything seemed fine, but somehow upon a reboot, they became snapshots.
That was 2 weeks ago, and we are gearing up to try the switch again.
We would like to know what causes the databases to convert to a snapshot? It's my understanding that a snapshot is a read-only database. Checking the properties for the databases shows the database read-only state as being false. I'm assuming that is the default value, and must be manually changed by the administrator? Every thing seems to be going ok this time, but we still have no idea how the databases got converted to snapshots last time and would like some tips as to what to look for.
Thanks.
Marshall