June 26, 2008 at 10:24 am
I try to restore previously saved back up of my website ( I use DNN ) database, it was saved as .bak file
I have SQL server management studio express 2005 installed so I open it and right click on database and choose restore database then I show it to restore from file and place tick on the database to be restored and click ok then I get this error ( I have to translate from russian so sorry if it not word to word as it would be in english version )
Action Restore ended unseccesfully for object "Server" "JULIA\SQLEXPRESS". (Microsoft.SqlServer.Express.Smo)
-----------------------------
Additional info:
System.Data.SqlClient.SqlError: Operating system returned an error "5(error not found)" when trying to "RestoreContainer::ValidateTargetForCreation" в "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\t2s.mdf". (Microsoft.SqlServer.Express.Smo)
there were also 2 links to see more about the errors but it led to this message "We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. "
aslo I have another database in .sql file an dI also don't know how to restore it on my computer for local usage....
June 27, 2008 at 9:24 am
Please check the path of restore as file..and make use it is changed to the new file u have created
June 28, 2008 at 1:01 am
well I have found the way out of this error 5
but still thinking about another problem I have is what to do with .sql file... I have had my database for the site that works on DNN and is currently online there was an option to export database and so I did, but it was exported into an .sql file.... now I have no idea what to do with this file and how to use it... it should ha?? been a mssql database and I thought it would be exported into bak file but this one was somehow exported in .sql.....
June 29, 2008 at 8:36 pm
TRY THIS:::
RESTORE DATABASE DATABASENAME
WITH REPLACE,
MOVE 'LOGICAL DATA FILENAME' TO 'PATH TO MDF FILE',
MOVE 'LOGICAL LOG FILENAME' TO 'OATH TO LDF FILE'
Maninder
www.dbanation.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply