All Questions
2 questions
0
votes
1
answer
4k
views
Restoring a SQL Server 2008 R2 backup on SQL Server 2005
I'm getting an error whenever I restore a testing database on SQL Server 2005 that was backed up from SQL Server 2008 R2. It seems that I cannot restore from a higher version of sql onto lower version,...
- 655
4
votes
3
answers
5k
views
Attempting to restore SQL Server 2005 database to a SQL Server 2008 R2 instance gives reason: 15105 error
I have a SQL Server 2005 database I am attempting to restore a SQL Server 2008 R2 SP2 machine using this statement:
RESTORE DATABASE [Db]
FROM DISK = N'C:\temp\sql\DB.bak' WITH FILE = 1,
MOVE N'...
- 161