Restore from backup - 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)

Restore from backup

Author

Topic

neil
Starting Member

29 Posts

Posted - 2004-01-06 : 10:52:59

Hello

I need to restore a database from a backup file, on a fresh installation of sql server.

When I try to restore I can't browse to select the backup file through EM, is it possible through TSQL ? It seems to only a allow me to select backup files it created.

Thanks

nr
SQLTeam MVY

12543 Posts

Posted - 2004-01-06 : 11:28:40

Use From Device then it will allow you to select the disk file.

Otherwise just use restore database from t-sql.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-06 : 12:28:01

RESTORE DATABASE DBNameGoesHere
FROM DISK = 'F:\MSSQL\Backup\SomeBackup.BAK'
WITH INIT

You need to include WITH MOVE if the path information for the MDF and LDF is going to be different than the source database.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources