Data Recovery Reports > Troubleshooting SQL Server Backup/Restore Problems

Databasejournal.com[Databasejournal.com] One of the causes for this error may be that the database is in SQL Server version 6.5 compatibility mode. Because the BACKUP and RESTORE keywords are valid only with SQL Server 7.0 and SQL Server 2000 databases, you should set the SQL Server compatibility level to 70 or 80.

Some related posts from Technorati and Google.

[Knowledgestorm.fastcompany.com] SQL Server - A Practical Guide to Backup,Recovery ...: Disaster Recovery (DR)-the process of restoring systems [including manual and automated business process] to an operational [state] after a catastrophic systems failure leading to a complete loss of operational capability.

[Techinterviews.com] SQL Server interview questions | TechInterviews.com | « Interview ...: If the SQL Server is running in mixed mode..then go to coonect to that sql server using windows authentication and then go to user-login and select the sa and change the password with new one….

[Dnnblog.venexus.com] Venexus DotNetNuke Blog - MS SQL Server: Troubleshooting utilities two new utilities ship with SQL 2005 to assist in the .I had used it on a SQL Server 2000 database to change all uppercase US .

Reflected tags on Technorati: Blog, ,