Importing data - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Importing data

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-11 : 14:03:45

rk writes "Hi,
I want to copy a database from SQL Server to another one (one computer to another computer physically very far). I got the backup file of the source database (in bkf format). now I want to restore/import this database in the destination machine. Please let me know how I can do this. I tried all the options like import/restore database. but nowhere I could see the option to restore the data from the backup database file of another computer.

Thanks in advance,
RK."

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-09-11 : 14:58:15

Find out the logical filenames from the backup

RESTORE FILELISTONLY FROM DISK='path to backup file'

Make a note of the logical names of the database and log files then

RESTORE DATABASE copy
FROM DISK='path to backup file'
WITH 
MOVE 'logical data name' TO 'file path for mdf',
MOVE 'logical log name' TO 'file path for ldf'

HTH
Jasper Smith

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources