Hi Raj,
The NT Event Log should be reviewed for additional errors. If SQL 7.0 and SQL 2000 are both running on this system, the Application Event Log might show the following error: 18210 : BackupVirtualDeviceSet::Initialize: CoCreateInstance failure on backup device 'TDPSQL-00000128-0000'. Operating system error -2147221164(Class not registered). This message indicates a problem with SQL Server where the SQL 7.0 vdi library is loaded before the SQL 2000 library. It is documented in Microsoft Knowledgebase article, Q280759, which can be reviewed at the following URL: http://support.microsoft.com/default.aspx?scid=kb;en-us;q280759 Please let me know if you need more info. Jim Neal Tivoli Administrator NASA/AMES T-28D Moffett, Ca 94035 650-604-1283 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Rajesh Oak Sent: Tuesday, March 11, 2003 2:37 PM To: [EMAIL PROTECTED] Subject: How to Backup MSDE databases? How can we backup the MSDE databases on the Server? I tried using the TDP for SQL but it gives me an error message: Received the following from the MS SQL server:[Microsoft][ODBC SQL Server Driver][SQL Server] Backup or Restore operation Terminated Abnormally.Microsoft SQL-DMO(ODBC SQL State:4200)(HRESULT:0x80040bc5) Is there a way to Backup the MSDE databases? I am using TDP for SQL v 2.2.1.0. on Windows 2000 Server. Rajesh Oak _____________________________________________________________ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
