I attempted to restore a database from backup (the same way I've done for
months in the past), but this time I got an error, and the database is marked
as LOADING and is not accessible. Help!
We have about 2 gigs free on the server, and our largest backup file/log is
211 mb.
How do I get my database out of (Loading) status, and restore my data?
The backup T-SQL is:
RESTORE DATABASE [dbname]
FROM DISK = 'e:\mssql7\backup\[filepath].bak'
WITH recovery,
MOVE 'wtc_data' TO 'e:\mssql7\data\[filename].mdf',
MOVE 'wtc_log' TO 'e:\mssql7\log\[filename].ldf'
The Error message is:
Server: Msg 3241, Level 16, State 37, Line 11
The media family on device 'e:\mssql7\backup\[filepath].bak' is incorrectly
formed. SQL Server cannot process this media family.
Server: Msg 3013, Level 16, State 1, Line 11
RESTORE DATABASE is terminating abnormally.
Is this SQL 7? If so, I believe that you would get these messages if you
were running out of space on the disk.
"Michael Schreiber" <Michael Schreiber@.discussions.microsoft.com> wrote in
message news:929B70D5-5B15-41EB-82D6-E84629DF8B77@.microsoft.com...
>I attempted to restore a database from backup (the same way I've done for
> months in the past), but this time I got an error, and the database is
> marked
> as LOADING and is not accessible. Help!
> We have about 2 gigs free on the server, and our largest backup file/log
> is
> 211 mb.
> How do I get my database out of (Loading) status, and restore my data?
> The backup T-SQL is:
> RESTORE DATABASE [dbname]
> FROM DISK = 'e:\mssql7\backup\[filepath].bak'
> WITH recovery,
> MOVE 'wtc_data' TO 'e:\mssql7\data\[filename].mdf',
> MOVE 'wtc_log' TO 'e:\mssql7\log\[filename].ldf'
> The Error message is:
> Server: Msg 3241, Level 16, State 37, Line 11
> The media family on device 'e:\mssql7\backup\[filepath].bak' is
> incorrectly
> formed. SQL Server cannot process this media family.
> Server: Msg 3013, Level 16, State 1, Line 11
> RESTORE DATABASE is terminating abnormally.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment