[code:tsql]
RESTORE DATABASE Enterprise
FROM DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Backup\Enterprise-20080403.bak'
WITH MOVE 'Enterprise' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Data\Enterprise.mdf',
MOVE 'Enterprise_log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Data\Enterprise_log.ldf',
STATS = 10, REPLACE
GO
[/code]
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
Processed 8760 pages for database 'Enterprise', file 'Enterprise' on file 1.
Processed 2 pages for database 'Enterprise', file 'Enterprise_log' on file 1.
RESTORE DATABASE successfully processed 8762 pages in 4.801 seconds (14.949 MB/sec).
Subscribe