Error when restoring the database in SQL

I have 3 database in SQL Server 7.0 (e.g. Company_1, Company_2 and Company_3), and I'm create 2 for new Db (Company_4 and Company_5), when I'm trying to restore from the backup data into the new Db which I just created, there is encounter the error as follow :

"Microsft SQL-DMO (ODBC SQL State : 42000). Backup or restore operation terminating abnormally."

Then the Database has corroupted and not able to open for Db Information.

However, I'm able to do restore in the other Db (the first 3 Db).

Surprise, why there isn't anybody to reply for my problem?, is there anybody to make clarify for my question ?.

|||Do 'restore verifyonly from <backup_device>' to check out the backup file. The message in your post simply means you have a corruption and sqlserver is not able to restore.

Error when restoring master database

Dear all,
I'm working on MS SQL 2000.
I stopped the SQL Server and the SQL Agent services.
and from the prompt:
sqlservr.exe -s MyInstanceName -c -m
then from QA, I've entered my MyInstanceName, user: sa and pwd.
and wrote there:
RESTORE DATABASE master FROM DISK = 'c:\master.bak'
I'm getting an error:
RESTORE DATABASE must be used in single user mode when trying to restore the
master database.
what am I missing'
Thanks in advance
joujI've discovered why. :$
I wasn't using the sqlservr.exe from MSSQl$MyInstanceName\Binn.
My problem now is the server version. I think I should install a Service
Pack for that the versions match.
Thanks.
"jouj" wrote:
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore the
> master database.
> what am I missing'
> Thanks in advance
> jouj|||sqlservr.exe -c - m -s {instancename}
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:C13BA8B2-490A-4365-8591-82C84F2BB0FB@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore
> the
> master database.
> what am I missing'
> Thanks in advance
> jouj

Error when restoring master database

Dear all,
I'm working on MS SQL 2000.
I stopped the SQL Server and the SQL Agent services.
and from the prompt:
sqlservr.exe -s MyInstanceName -c -m
then from QA, I've entered my MyInstanceName, user: sa and pwd.
and wrote there:
RESTORE DATABASE master FROM DISK = 'c:\master.bak'
I'm getting an error:
RESTORE DATABASE must be used in single user mode when trying to restore the
master database.
what am I missing?
Thanks in advance
jouj
I've discovered why. :$
I wasn't using the sqlservr.exe from MSSQl$MyInstanceName\Binn.
My problem now is the server version. I think I should install a Service
Pack for that the versions match.
Thanks.
"jouj" wrote:

> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore the
> master database.
> what am I missing?
> Thanks in advance
> jouj
|||sqlservr.exe -c - m -s {instancename}
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:C13BA8B2-490A-4365-8591-82C84F2BB0FB@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore
> the
> master database.
> what am I missing?
> Thanks in advance
> jouj
sql

Error when restoring master database

Dear all,
I'm working on MS SQL 2000.
I stopped the SQL Server and the SQL Agent services.
and from the prompt:
sqlservr.exe -s MyInstanceName -c -m
then from QA, I've entered my MyInstanceName, user: sa and pwd.
and wrote there:
RESTORE DATABASE master FROM DISK = 'c:\master.bak'
I'm getting an error:
RESTORE DATABASE must be used in single user mode when trying to restore the
master database.
what am I missing'
Thanks in advance
joujI've discovered why. :$
I wasn't using the sqlservr.exe from MSSQl$MyInstanceName\Binn.
My problem now is the server version. I think I should install a Service
Pack for that the versions match.
Thanks.
"jouj" wrote:

> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore t
he
> master database.
> what am I missing'
> Thanks in advance
> jouj|||sqlservr.exe -c - m -s {instancename}
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:C13BA8B2-490A-4365-8591-82C84F2BB0FB@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore
> the
> master database.
> what am I missing'
> Thanks in advance
> jouj

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.

Error when restoring an SQL database

Hello,
Not sure if I've hit the right newsgroup, my apologies if not.
I work with a small software firm, whereby we predominantly develop Point of
Sale software, which can typically contain very large membership databases
(used at Universities and Sporting Venues).
I have received a backup from one of our clients, but am having issues
trying to restore it via Enterprise Manager. I am selecting a device, as I
have the .bak file sitting on my local hard drive, and selecting one device
only.
From the Restore database window, when I click on the Options tab, I get the
following error:
"Error 3205: Too many backup devices specified for backup or restore; only
64 are allowed. RESTORE FILELIST is terminating abnormally."
I can then click on OK and see the rest of the options screen, yet the
Logical file name and Move to physical file name options are left blank.
Even if I try to enter these fields manually and click on OK, I get a
similar error but with RESTORE DATABASE is terminating abnormally.
Is something going wrong with the way the client is backing up the data? I
don't know exactly what procedure they are using, but I'm assuming they are
just using the backup function from with Enterprise Manager.
Could something be going wrong with the way they are sending me the
database? I have received to copies, one as a spanned Zip file and one as a
spanned Winrar file, but I have the same issue with both copies.
Any advise would be appreciated.
Adrian Robertson
CENTAMAN SystemsAdrian,
from your description it seems like the fileheader of the backup file
is corrupt. The restore process can't read the information about the
logical name and the physical path. You can try to run RESTORE
HEADERONLY but I suspest that you get the same error.
Markus|||Hi Marcus
I tried the "View Contents" option and got a similar error, but I can't see
any option to restore headers only (though I agree, I think I'll have the
same issue).
Should I see this in the same area somewhere?
I'm using Microsoft SQL Enterprise Manager version 8.0 if that's any help.
In the event that the header record is corrupt as you suggest, is there
anything I can suggest the client do to improve their backup procedure, or
is this likely to be an issue in the underlying database?
Adrian
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1144220472.886147.50950@.u72g2000cwu.googlegroups.com...
> Adrian,
> from your description it seems like the fileheader of the backup file
> is corrupt. The restore process can't read the information about the
> logical name and the physical path. You can try to run RESTORE
> HEADERONLY but I suspest that you get the same error.
> Markus
>|||Hi,
I think it might be a version compatibility issue. The client is running SQL
Server 2005 9.00.1399
Typically I am running SQL Server 2000
I have a developers edition of SQL Server 2005 9.00.1116, but even when
using this I am unable to restore a backup created in 9.00.1399.
Are there any options in SQL Server 2005 that allows you to take a backup
that will be backward compatible?
Adrian
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1144220472.886147.50950@.u72g2000cwu.googlegroups.com...
> Adrian,
> from your description it seems like the fileheader of the backup file
> is corrupt. The restore process can't read the information about the
> logical name and the physical path. You can try to run RESTORE
> HEADERONLY but I suspest that you get the same error.
> Markus
>sql