I am working with SQL server 2000. The database is installed in my machine. Now I have got the ".ldf" and ".mdf" file pertaining to a database from someother server.
Is it possible to build the database present in the above said files in my server.
NOTE : I dont have a direct access to the remote server from where the above said files were obtained (otherwise I think the DTS utility would have come in handy).An example from The Holy book
This example attaches two files from pubs to the current server.
EXEC sp_attach_db @.dbname = N'pubs', @.filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf', @.filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'|||Thanks for the instant help . That worked !|||BTW, the imported database seems to have a lot of procedures like dt_addtosourcecontrol, dt_adduserobject etc.. what are these for ?|||You might want to take a peek at Microsoft Knowledge Base Article 218172 when attaching/detaching databases on different servers.
No comments:
Post a Comment