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...
> > 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.
>|||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/scripts/scriptdetails.asp?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.

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

Move/Upgrade SQL 6.5 Databases to SQL 2K

I am running into problems when attempting to move
databases from SQL 6.5 to SQL 2K. There is a known bug in
SQL2K, SP3a when using the migration wizard. The work
around involved installing 6.5 on a Windows 2000 Server
but we ran into problems with that as well. Microsoft
actually removed their White Paper on this subject from
their site. Does anyone know of a good information source
for instructions on how to do this?Try to detach the databases from source 6.5 server, copy
the your database mdf and ldf file to your destination
server server and attach the database. Also look into
moving your logins account to that server
>--Original Message--
>I am running into problems when attempting to move
>databases from SQL 6.5 to SQL 2K. There is a known bug
in
>SQL2K, SP3a when using the migration wizard. The work
>around involved installing 6.5 on a Windows 2000 Server
>but we ran into problems with that as well. Microsoft
>actually removed their White Paper on this subject from
>their site. Does anyone know of a good information
source
>for instructions on how to do this?
>.
>

move/upgrade MSDE to SQL 2000

Need some help with moving/upgrading 3 MSDE databases (stored locally on 3 different servers) to a single SQL 2000 server (new instance). Can this be done? If so, how??

Thanks for any responsesStop the MSSQL service. Find the MDF and LDF files (C:\Program Files\Microsoft SQL Server\MSSQL\Data\ ) and copy them to the SQL Server. Then attach the databases on the destination. Watch not to overlay any MDF/LDF files on the destination server.sql

move or upgrade MSDE to Sql server 2000 server

We have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.
ThanksWe have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.

Thanks
See this http://support.microsoft.com/default.aspx?scid=kb;en-us;815013#2 (http://support.microsoft.com/default.aspx?scid=kb;en-us;815013#2)|||Let's say I understand that MS site. How do the 3 MSDE databases get into 1 SQL database?

Thanks...|||Let's say I understand that MS site. How do the 3 MSDE databases get into 1 SQL database?

Thanks...
Oops!! Sorry,its my mistake ,I paste the wrong link .Please see this one...
http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-my-msde-database-to-full-blown-sql-server-2000.html (http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-my-msde-database-to-full-blown-sql-server-2000.html)
It may help you...