Friday, March 30, 2012

Moving an SQL 2000 database

I am going to be performing an upgrade on a 2000 server. I
will be adding two drives (mirrored). The server is
running 'ACT! Web' which uses SQL. I would like to move
the SQL database to the newly created volume, I am very
green when it comes to SQL, so I don't really know where
to begin.
If anyone hase some suggestions please post.Look up sp_detach_db and sp_attach_db in BOL.
"Steve" <deviller@.starbeam.ca> wrote in message
news:7b9001c402e7$cc7cd310$a001280a@.phx.gbl...
> I am going to be performing an upgrade on a 2000 server. I
> will be adding two drives (mirrored). The server is
> running 'ACT! Web' which uses SQL. I would like to move
> the SQL database to the newly created volume, I am very
> green when it comes to SQL, so I don't really know where
> to begin.
> If anyone hase some suggestions please post.|||And for some more reading, KB article 224071.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in message
news:O2yXqhuAEHA.3184@.TK2MSFTNGP09.phx.gbl...
> Look up sp_detach_db and sp_attach_db in BOL.
> "Steve" <deviller@.starbeam.ca> wrote in message
> news:7b9001c402e7$cc7cd310$a001280a@.phx.gbl...
>|||Steve wrote:
> I am going to be performing an upgrade on a 2000 server. I
> will be adding two drives (mirrored). The server is
> running 'ACT! Web' which uses SQL. I would like to move
> the SQL database to the newly created volume, I am very
> green when it comes to SQL, so I don't really know where
> to begin.
> If anyone hase some suggestions please post.
Look into Detach/Attach. See:
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSqlLogins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scr...sp?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.sql

No comments:

Post a Comment