1 Message

June 22nd, 2016 09:00

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 = 'D:\BACKUPS\MyDatabase.bak'

    WITH NOFORMAT, NOINIT,

    NAME = 'MyDatabase-Full Database Backup',

    NOREWIND, NOUNLOAD, STATS = 10, SKIP

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

Again, change your names and locations to suit.

May be this article will give you more information.

http://www.techrepublic.com/forums/questions/it-seems-our-sql-database-is-corrupted/

June 25th, 2016 15:00

Thanks for the advice. Your link was very useful for me! Thank you!

9 Legend

 • 

87.5K Posts

June 14th, 2016 11:00

Are both servers running the same service pack (SP4) on SQL 2008?

No Events found!

Top