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.0
The 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.0
Friday, March 23, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment