Trail Blazer Knowledge Base:


Home : MS SQL Server : SQL Server Restore .BAK files

Knowledge Base







User:

Password:



Article ID: KB64
Keyword Name:
Created: April 03, 2008
Viewed: 4399

SQL Server Restore .BAK files

open a command prompt from SQL Server box.

[start] [run] cmd.exe [Enter]
Type osql -E [Enter] you should get a 1> prompt type each line, [Enter] at the end of line.

1> RESTORE DATABASE DBName
2> FROM DISK = 'C:\Backup.BAK'
3> WITH REPLACE, MOVE 'DBName_Data' TO 'C:\MSSQL\DATA\DBName_Data.MDF',
4> MOVE 'DBName_Log' TO 'C:\MSSQL\DATA\DBName_Log.LDF'

 



Find our more information about Trail Blazer Campaign Services Inc. [click here]


Powered by: ClickCarts KnowledgeBase