Friday, March 23, 2012

I want to restore a database but it show me a mistake

I need restore a database but appears the nex error
Microsoft SQL-DMO 9 (ODBC SQLState: 42000)
Tha backup set holds a backup of a database other than the existing 'ACCESSCONTROL' database Backup or Restore operation terminating abnormally
What Can I Do for to resolve this error?
The SqlServer version 7.0The backup that you are restoring is of a different databse to the one =you are restoring, thus the error you are getting is a warning that =youwill be overwriting an existing database wich you may not intend to =do. The RESTORE SQl statement has an option WITH REPLACE, which =overrides this warning so if you really want to do what you are asking =it to do adding the equivalent optionshould fix your problem. If you =have yoiur own app using SQl DMO, then there should be an equivalent =option within DMO.
Mike John
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message =news:0CC8EAC8-8200-47B0-9D8A-F3E5743F9837@.microsoft.com...
> I need restore a database but appears the nex error
> Microsoft SQL-DMO 9 (ODBC SQLState: 42000)
> Tha backup set holds a backup of a database other than the existing ='ACCESSCONTROL' database Backup or Restore operation terminating =abnormally
> What Can I Do for to resolve this error?
> The SqlServer version 7.0sql

No comments:

Post a Comment