I'm trying to restore a database on my SQL Server 2005 Express server from a *.bak file, and almost immediately after I press the ok-button, I get this error message:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Restore failed for Server 'TH-LT\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The operating system returned the error '3(error not found)' while attempting 'CreateFile' on 'c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\c4world_2.ForumFullTextCatalo g\SQL.HDR'. (Microsoft.SqlServer.Express.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdN...0&LinkId=20476
------------------------------
Can anyone provide me with some help? Is it because I'm restoring a database from a SQL Server 2005 Standard to SQL Server 2005 Express?
I run the "SQL Server Management Studio Express" as administrator