469,325 Members | 1,491 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,325 developers. It's quick & easy.

Restore database in SQL 2005

Here is the Example to Restore database in SQL 2005

RESTORE DATABASE DBNAME
FROM DISK ='D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\DBNAME_db.bak'
WITH MOVE 'DBNAME_log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\DBNAME.MDF',
MOVE 'DBNAME_data' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\DBNAME_log.LDF',
STATS = 1, REPLACE
GO
Apr 23 '07 #1
0 3193

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by ad | last post: by
2 posts views Thread by phil2phil | last post: by
1 post views Thread by Utahduck | last post: by
3 posts views Thread by Bill E. | last post: by
5 posts views Thread by Seguros Catatumbo | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.