Showing posts with label restore. Show all posts
Showing posts with label restore. Show all posts

Thursday, March 29, 2012

error when trying to restore a sql7 master database

I'm trying to restore a sql7 database on a NT4 Entreprise
SQL server.
I rebuild the master database with Rebuildm.exe and I
start the single user mode with d:\mssql7
\binn\sqlservr.exe -m
When I start the restore with Brighstore ArcServe, I have
this error:
Error: 605. Severity: 21, State: 1.
Error: 63151. Severity: 21, State: 0.
The master database falied to restore. Use the
rebuildm.exe utility to rebuild the master database.
Shutting down SQL Server.
Anyone can help me ?Sorry, you have the wrong usergroup.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Francosi Thibault" <anonymous@.discussions.microsoft.com> wrote in message
news:23a7601c45eac$24a9a520$a401280a@.phx.gbl...
> I'm trying to restore a sql7 database on a NT4 Entreprise
> SQL server.
> I rebuild the master database with Rebuildm.exe and I
> start the single user mode with d:\mssql7
> \binn\sqlservr.exe -m
> When I start the restore with Brighstore ArcServe, I have
> this error:
> Error: 605. Severity: 21, State: 1.
> Error: 63151. Severity: 21, State: 0.
> The master database falied to restore. Use the
> rebuildm.exe utility to rebuild the master database.
> Shutting down SQL Server.
> Anyone can help me ?

Monday, March 26, 2012

Error when Restoring Full Backup with NORECOVERY

I restored a full backup with NORECOVERY because I need to restore the differentials for the week. When I try to restore the differential i receive the following:

System.Data.SqlClient.SqlError: This differential backup cannot be restored because the database has not been restored to the correct earlier state. (Microsoft.SqlServer.Smo)

The database that reads the dbname (Restoring...).

Does anyone know what I need to do?

Thank you in advance.

Julio

I have replied you here.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1896613&SiteID=1

Error when restoring database

Hi guys!
I wonder if this happened to you... I searched and found nothing related to this problem...
When I try to restore a database in SQL Server Management Studio on a 2005 database engine I receive the message:

Cannot show requested dialog.


ADDITIONAL INFORMATION:

Could not load file or assembly 'SqlManagerUI, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A) (mscorlib)

Strong name validation failed. (Exception from HRESULT: 0x8013141A)

Sometimes I receive the same error when starting Management Studio for the connection dialog...

Thank you!

This error means that one or more of the SQL DLL's has been corrupted such that the binary data in the file no longer matches the file that was signed by Microsoft.

Most common causes of this kind of corruption:

1) Viruses or other malware
2) File system corruption
3) Failing hard drive|||I'm seeing this error too. I a reinstall indicated?|||

I have got the same ERROR message too.

Configuration:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft .NET Framework 2.0.50727.42
Hardware Disk Drive HTS721080G9SA00

bg,
Selim

|||

Try rerunning the setup and repair all the components (Dont chose for a custom install)
Hope this helps.

Thanks,
Kuntal

|||Have you tried to accessing the same from another client's machine?|||

I have reinstalled Win XP Pro, then installed SQL 2005 Developer Edition + SP1
and now works fine :)

thnx,
Selim

|||Oh if you think that was easy then so be it, if it occurs next time then make sure to check.

Error when restoring database

Hi guys!
I wonder if this happened to you... I searched and found nothing related to this problem...
When I try to restore a database in SQL Server Management Studio on a 2005 database engine I receive the message:

Cannot show requested dialog.


ADDITIONAL INFORMATION:

Could not load file or assembly 'SqlManagerUI, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A) (mscorlib)

Strong name validation failed. (Exception from HRESULT: 0x8013141A)

Sometimes I receive the same error when starting Management Studio for the connection dialog...

Thank you!

This error means that one or more of the SQL DLL's has been corrupted such that the binary data in the file no longer matches the file that was signed by Microsoft.

Most common causes of this kind of corruption:

1) Viruses or other malware
2) File system corruption
3) Failing hard drive|||I'm seeing this error too. I a reinstall indicated?|||

I have got the same ERROR message too.

Configuration:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft .NET Framework 2.0.50727.42
Hardware Disk Drive HTS721080G9SA00

bg,
Selim

|||

Try rerunning the setup and repair all the components (Dont chose for a custom install)
Hope this helps.

Thanks,
Kuntal

|||Have you tried to accessing the same from another client's machine?|||

I have reinstalled Win XP Pro, then installed SQL 2005 Developer Edition + SP1
and now works fine :)

thnx,
Selim

|||Oh if you think that was easy then so be it, if it occurs next time then make sure to check.