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.
OrnSveinsson
1 Message
1
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/
silas.perkins
2 Posts
0
June 25th, 2016 15:00
Thanks for the advice. Your link was very useful for me! Thank you!
ejn63
9 Legend
•
87.5K Posts
1
June 14th, 2016 11:00
Are both servers running the same service pack (SP4) on SQL 2008?