Best Practices for suspending a SQL Server for maintenance

What are the best practices for suspending a non-clustered/non-fault tolerant SQL 2008 server for maintenance?

We have a SQL 2008 server in a hosted environment.  The transaction log files and the DB files sit on SAN LUNS presented to the physical SQL server.  Our host/vendor is migrating all data off that current SAN to a new SAN.  Therefore, I want to stop all SQL prior to the move, then bring SQL back online after the SAN migration is complete.

Thanks,

Cw.
craig16229Asked:
Who is Participating?
 
almanderConnect With a Mentor Commented:
I guess it depends on what the vendor means by 'migrating' to me that means that they will take care of everything including the detach/stopping and reattach/starting of the databases. Otherwise they could not guarantee that your data and log files are current.

Regardless, someone should be doing something similar to:
1. Stop writing to the files
2. Copy the files
3. Allow writing to the files

Assuming that there are no changes to the server, or to the servers MASTER database. A reattach, or even restore from backup will have a very, very high success rate. Obviously and data changes made after the backup, or copy of the mdf/ldf files would not be in the newly restored/reattached version.





0
 
almanderCommented:
Regardless of what you do, make a backup of the database!

To perform the move, I would
1. Detach the current database(s).
2. Move the Database (mdf), and Log (ldf) files to the new location.
3. Reattach the database(s).

http://support.microsoft.com/kb/224071
0
 
craig16229Author Commented:
Almander,

Thanks for your rapid reply, and the link.  I did not come across that MS KB, and that is at least part of what I am looking for.

Our vendor is telling us that essentially they are migrating our data for us.  So aside from the backup (which is obviously a good idea no matter what the vendor says), what are the prospects of  re-attaching the databases after the move and having SQL come back online?


Cw.
0
 
craig16229Author Commented:
The vendor is definitely expecting us to have production shut down on our servers prior to the move, but their promise (which I translate into "vendor promise") is that they will migrate the data pristinely.

We'll see about that when I re-attach to the databases.


Cw.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.