importing data 1

[teroy]

Hi there..I have databases on a copy of sql server(which is not working) which i want to copy over to another server. I thought it would be as easy as getting the *.mdf and *.ldf files for the particular database and putting it in the \mssql7\data directory but i'm missing a few steps along the way.

Can anyone point me in the right direction as to the best approach to get these files in. On the server(which is not working) i cannot connect and make exports to csv or another format...which is why i went straight for the files in the data directory

Thanks in advance

 

[Bernadette]

Hi There Teroy

You are halfway there already.
After you have put the files in the data directory of the new server, run the following to attach the database to the new server.

EXEC sp_attach_db @dbname = 'MyDb',
@filename1 = 'c:\mssql7\data\MyDb.mdf',
@filename2 = 'c:\mssql7\data\MyDb_log.ldf'


Hope This Helps
Bernadette

 

[teroy]

Thanks Bernadette..that worked perfectly )

 

[Bernadette]

I am glad to hear that ... you are welcome Teroy

Cheers
Bernadette