Restoring a database from another SQL Server

Restoring a database from another SQL Server

Postby stephen » Wed May 24, 2006 2:01 pm

Web Site explains restoring a database from another sql server

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1102260,00.html

RESTORE FILELISTONLY

This is another command that can be run on the backup files.

RESTORE FILELISTONLY FROM DISK = 'C:\SQL\Backup\North.bak'

RESTORE DATABASE NORTH
FROM DISK = 'C:\SQL\Backup\North.bak'
WITH MOVE 'NORTH_Data' TO 'D:\SQL\Data\North_Data.mdf',
MOVE 'NORTH_Log' TO 'E:\SQL\Log\North_Log.ldf'
stephen
 
Posts: 507
Joined: Thu Feb 09, 2006 9:37 am
Location: Brisbane

Return to SQL Server Help

Who is online

Users browsing this forum: No registered users and 1 guest

cron