SAN Upgrade.

Hi All,
We are about to do a SAN upgrade and I was wondering what the best option
for moving our SQL2000 databases from one SAN to the other is?
Am I safe to simply stop the SQL services, move the database files across,
re-assign the drive letters etc and then restart SQL?
Any wisdom will be gratefully received!
Thanks!
Aaron
Hi Aaron,
I think you're quite safe, but what I would do is:
1. deattach databases
2. copy databases
3. reassign drive letters
4. attach databases.
Of course a backup is more then recommended before anything else.
Danijel Novak
"Aaron Elliott" <AaronElliott@.discussions.microsoft.com> wrote in message
news:684FC7D7-20A9-4EA0-A7AD-8DEB51A16498@.microsoft.com...
> Hi All,
> We are about to do a SAN upgrade and I was wondering what the best option
> for moving our SQL2000 databases from one SAN to the other is?
> Am I safe to simply stop the SQL services, move the database files across,
> re-assign the drive letters etc and then restart SQL?
> Any wisdom will be gratefully received!
> Thanks!
> Aaron
|||A backup will be done in more ways that one!
I gather detaching and re-attaching will retain users as well?
I also need to move all the system databases as well...
Thanks!
"Danijel Novak" wrote:

> Hi Aaron,
> I think you're quite safe, but what I would do is:
> 1. deattach databases
> 2. copy databases
> 3. reassign drive letters
> 4. attach databases.
> Of course a backup is more then recommended before anything else.
> --
> Danijel Novak
>
> "Aaron Elliott" <AaronElliott@.discussions.microsoft.com> wrote in message
> news:684FC7D7-20A9-4EA0-A7AD-8DEB51A16498@.microsoft.com...
>
>
|||Hi,
Yes detaching and attaching will retain users.
For system databases I would just copy them:
1. copy databases
2. reassign drive letters
3. start SQL
Danijel Novak
"Aaron Elliott" <AaronElliott@.discussions.microsoft.com> wrote in message
news:0713888C-EF01-4F91-BBEF-A2FAB0DE68B0@.microsoft.com...[vbcol=seagreen]
> A backup will be done in more ways that one!
> I gather detaching and re-attaching will retain users as well?
> I also need to move all the system databases as well...
> Thanks!
> "Danijel Novak" wrote:
|||These might come in handy:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scri...tions/1598.asp Script
Roles and Permissions
Andrew J. Kelly SQL MVP
"Aaron Elliott" <AaronElliott@.discussions.microsoft.com> wrote in message
news:684FC7D7-20A9-4EA0-A7AD-8DEB51A16498@.microsoft.com...
> Hi All,
> We are about to do a SAN upgrade and I was wondering what the best option
> for moving our SQL2000 databases from one SAN to the other is?
> Am I safe to simply stop the SQL services, move the database files across,
> re-assign the drive letters etc and then restart SQL?
> Any wisdom will be gratefully received!
> Thanks!
> Aaron