RESTORE DATABASE YourDatabaseName
FROM DISK = N'(path to your BAK file)'
WITH FILE = 1,
MOVE N'(your DB name)' TO N'(your SQL path)database.MDF',
MOVE N'(your DB name)_LOG' TO N'(your SQL path)database_LOG.LDF',
NOUNLOAD,
REPLACE,
STATS = 10
GO
By
http://stackoverflow.com/questions/6217679/create-restore-database-from-backup-sql-server-express
SQL Performance Dashboard Reports
Há 4 anos
2 comentários:
Great tip, still i have a doubt regarding to which is my SQL path, is it something like this ?
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\...
Cheers, tks :)
Hei T0ze,
Yes this can be the path where you have bakups.
But it could be any other
Best regards
Daniel Maia
Enviar um comentário