-
Member
MSSQL 2005 Error
Hey Im getting this error, I have tryed many things, can someone help me out with fixing it? Thanks in advance.
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Restore failed for Server 'UBERWARE1-1\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: Source: ID: ( ) - Events And Errors Message Center: Message Details
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ACCOUNT_DBF.mdf'. (Microsoft.SqlServer.Express.Smo)
For help, click: Source: ID: (SQL Server 9.00.4035.00) - Events And Errors Message Center: Message Details
------------------------------
BUTTONS:
OK
------------------------------
-
-
ASDFGHJKL
Re: MSSQL 2005 Error
is this in restoring database?
-
Member
Re: MSSQL 2005 Error
Yeah, Just like Dell Honne said to do on the thread for the v15 files.
-
ASDFGHJKL
Re: MSSQL 2005 Error
in the Restore Database Window.
General:
Destination for restore-
To database : ACCOUNT_DBF
To a point in time : Most recent possible
Source for restore
Click From device > click ... > Add > choose the .bak file. > Ok.
Select the backup sets to restore
Put a check in Restore.
Then Click Options on the left.
Check Overwrite the existing database.
In Restore the database file as.
click the (...) then C://Program files/Microsoft SQL Server/MSQQL.1/MSSQL/Data/Account_mdf > Ok.
Do in the following lines.
Try these.
-
Member
Re: MSSQL 2005 Error
I dont have a Account_mdf O.o only, ACCOUNT_DBF and when I have it selected it shows a ACCOUNT_DBF_log. I still get that error
---------- Post added at 07:01 AM ---------- Previous post was at 06:36 AM ----------
Im going another route with just going and adding the db's through the just a database download.
-
Account Upgraded | Title Enabled!
Re: MSSQL 2005 Error
Try attaching it instead of restoring it
-
ASDFGHJKL
Re: MSSQL 2005 Error
What i mean is Account_DBF.mdf and ACCOUNT_DBF_LOG.ldf. IDK the exact name
-
Member
Re: MSSQL 2005 Error
Heres the thing, I don't have a mdf >.> and log only shows up when trying to recover it. I have even tryed going in, uninstalling sql and everything about 4 times and reinstalled it and tryed to get a clean slate, seems not to though, still know my info