I'm having trouble restoring SQL database
-
Solved
So i'm pretty new to SQL databases (more of a MySQL guy). I'm trying to create a new database with an external backup someone created for me.
I'm using:
Microsoft SQL Server Management Studio Express v9.0
SQL server 2005
And following this tutorial:
http://www.linglom.com/2008/01/12/how-to-backup-and-restore-database-on-microsoft-sql-server-2005/
When i try to specify the backup location, i get the following error:
Now, i think my SQL service account has access to the path, so it should work, right?
At a loss for what to do next. Driving me nuts
-
Can u please post the error message and error number u are getting.
-
SOLVED
Don't worry, it has been solved.
-
Glad you solved the problem. Proper forum etiquette, however, is for you post how you solved the problem. Others may have the same or similar problem and seeing what you did may be helpful.
-
good point.
Basically, in the screenshot below, i changed the option to 'Local system account'.
So, it was to do with my account having permissions to use the SQL service
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply