November 14, 2003 at 12:13 pm
I am doing an SQL restore. The STAT parameter tells SQL Server to
"Displays a message each time another percentage completes and is used to gauge progress. If percentage is omitted, SQL Server displays a message after every 10 percent completed."
I am running the following statements via Query Analyser:
RESTORE DATABASE DB1
FROM DISK = 'K:\Backups\DB1.bak'
WITH
MOVE 'DB1_Data' TO 'k:\SQL\DB1_data.mdf'
,MOVE 'DB1_Log' TO 'l:\SQL\DB1_Log.ldf'
,REPLACE
Why isn't the progress message being displayed in the messages window of Query Analyser?
November 14, 2003 at 2:44 pm
You omitted not only the percentage but also the entire option. Try:
RESTORE DATABASE DB1
FROM DISK = 'K:\Backups\DB1.bak'
WITH
MOVE 'DB1_Data' TO 'k:\SQL\DB1_data.mdf'
,MOVE 'DB1_Log' TO 'l:\SQL\DB1_Log.ldf'
,REPLACE
,STATS
--Jonathan
--Jonathan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply