However, I have restored many databases and I recall something like this working just fine:

restore database Try_Palma from disk = 'D:mssqlbackupMYPalma.bak'

Now, it's just not working. What could be the problem?

Make sure you have the path correct and that the SQL Server service account has the proper privileges to open the file you are specifying. A simple task would be to run the following command to make sure you can see the file in the operating system:

Xp_cmdshell 'dir D:mssqlbackupMYPalma.bak'

This should return the results if the file exists. Also, the D: and C: parameters without the backslash will probably have you searching in the system folders on the server. So just check to make sure you have the correct path for the backup files.

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy