restore a sql 2000 database from a copy

I want to copy a sql 2000 database into another sql 2000 machine. I
made a copy of the data folder and put it on a CD for transport. Now
I need to know how to put it into a fresh install of sql server 2000.
Have a look at sp_attach_db in Books On Line. Also
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default...;EN-US;q224071
You could also have just done a backup and restore
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
You may need to synchronise the database users with the logins on the new
server
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default...;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default...;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default...;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default...;en-us;Q274188
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<kg7poe@.yahoo.com> wrote in message
news:tnf4b0dsntr9a7cl94nqdu8stdkoaje67f@.4ax.com...
> I want to copy a sql 2000 database into another sql 2000 machine. I
> made a copy of the data folder and put it on a CD for transport. Now
> I need to know how to put it into a fresh install of sql server 2000.
>
|||You still have the original server and databases, right?
Making a copy of the data file is not the correct way to move a database
from one server to another. You might want to take a look at the
backup/restore commands, sp_attach_db, or the Copy Database Wizard in
Enterprise Manager...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
<kg7poe@.yahoo.com> wrote in message
news:tnf4b0dsntr9a7cl94nqdu8stdkoaje67f@.4ax.com...
> I want to copy a sql 2000 database into another sql 2000 machine. I
> made a copy of the data folder and put it on a CD for transport. Now
> I need to know how to put it into a fresh install of sql server 2000.
>
|||See this thread - I posted some info here about using BACKUP and RESTORE in QUERY ANALYZER to move DB from production to a development server.
http://www.microsoft.com/sql/communi...f-221662329ed5
|||Hi,
Follow the below steps:-
1. Copy the MDF and LDF files of your required database from CD to local
hard disk of server
2. Say you have 2 files (Finance_data.MDF and Finance_log.LDF)
3. copy both the files to c:\data folder
4. Login to SQL Server using Query ANalyzer as SA and execute below
command:-
sp_attach_db
'dbname','c:\data\Finance_data.MDF','c:\data\Finan ce_log.LDF'
This will attach the database to your server. Have a look into the below
procedure in books online to
syncrnize the logins/users after attaching.
sp_change_users_login
(SP_ATTACH_DB may not work since you have not detached the database properly
from source server. If it is not working then do the below in source
server:-
1. Detach the database using SP_DETACH_DB <dbname>
2. COpy the MDF and LDF to new place
3. Attach the database back in the server using SP_ATTACH_DB <DBName>,'MDF
file','LDF FIle'
4. Cut the CD using this MDF and LDF file taken in step 2
5. Ship the CD to destination and collow the steps mentioned in the first
part of mail.
Thanks
Hari
MCDBA
<kg7poe@.yahoo.com> wrote in message
news:tnf4b0dsntr9a7cl94nqdu8stdkoaje67f@.4ax.com...
> I want to copy a sql 2000 database into another sql 2000 machine. I
> made a copy of the data folder and put it on a CD for transport. Now
> I need to know how to put it into a fresh install of sql server 2000.
>