If that doesn't work, try to restore a database by third-party tools. You can find them a lot in Google. If you don't want to spend the time looking, you can try a proven tool SQL Server Recovery Toolbox. All the details about this program can be found at the link...
Copy your backup file to the other server, and there do:
RESTORE DATABASE MyDatabase
FROM DISK = 'E:\Backups\MyDatabase.bak' WITH FILE = 1,
MOVE 'MyDatabase_Data' TO 'E:\SQLDATA\MyDatabase_Data.mdf',
MOVE 'MyDatabase_Log' TO 'E:\SQLLOG\MyDatabase_Data.ldf',
NOUNLOAD, REPLACE, STATS = 10...
Try doing the backup and restore via SQLCMD (or via a query window in SQL Server MS).
The backup would be as follows (obviously, change "MyDatabase" and "D:\BACKUPS" to whatever database and location you want to back up - just using for example):
BACKUP DATABASE MyDatabase
TO DISK =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.