SQL-DMO
ReplaceDatabase Property
The ReplaceDatabase property directs a restore operation when a new image of the restored database is required.
Applies To
| Restore Object |
Syntax
object.ReplaceDatabase [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetReplaceDatabase(LPBOOL pRetVal);
HRESULT SetReplaceDatabase(BOOL NewValue);
Remarks
If TRUE, a new image of the database is created. The image is created regardless of the presence of an existing database with the same name.
If FALSE (default), a new image of the database is not created by the restore operation. The database targeted by the restore operation must exist on an instance of Microsoft® SQL Server™ 2000.