Restore

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Restore

Restore

Rate Topic

Display Mode

Topic Options

Author

Message

Sqlchamp

Posted Monday, September 15, 2008 4:10 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 02, 2009 12:14 PM
Points: 14, Visits: 113

RESTORE DATABASE test
--restore filelistonly
FROM DISK = 'D:\BACKUP\test_db_200809150315.BAK'
WITH NORECOVERY,
with MOVE 'tws_dat' TO 'D:\Data\test.mdf',
with MOVE 'tws_Log' TO 'D:\LOG\test_log.ldf'

What is wrong with this above syntax, I am getting incorrect syntax near the keyword 'with'. Thank you.

Post #569854

happycat59

Posted Monday, September 15, 2008 9:46 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:45 PM
Points: 2,471, Visits: 2,065

You only need to specify "WITH" once...
RESTORE DATABASE test
--restore filelistonly
FROM DISK = 'D:\BACKUP\test_db_200809150315.BAK'
WITH NORECOVERY,
MOVE 'tws_dat' TO 'D:\Data\test.mdf',
MOVE 'tws_Log' TO 'D:\LOG\test_log.ldf'

Post #569914

Sqlchamp

Posted Tuesday, September 16, 2008 9:24 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 02, 2009 12:14 PM
Points: 14, Visits: 113

Thank you. It works.

Post #570354

« Prev Topic | Next Topic »

Permissions