1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Sql Restore problem

Discussion in 'Business Applications' started by TegGEr, Nov 22, 2001.

Thread Status:
Not open for further replies.
  1. TegGEr

    TegGEr Thread Starter

    Joined:
    Nov 22, 2001
    Messages:
    4
    Im having difficulty trying to restore a database on a differend SQL server....

    I have ran a backup on the SQL server1 using the Backup wizard and doing a complete backup then I copied that backup set on to new server on the new server I ran the restore wizard and chose from device I chose the backup set from SQL server 1 and then try to run the backup I get a "microsoft SQL-DMO (ODBC SQLsTATE: 42000)" the file XX.MDf cannot be used by RESTORE. consider using the with move option to identify a valid location for the file. backup or restore operation terminating abnormally.
     
  2. eddie5659

    eddie5659 Moderator Malware Specialist

    Joined:
    Mar 19, 2001
    Messages:
    35,126
  3. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    Do you already have an Enterprise Manager connection to the other server? Shouldn't be an problem at all if you have the connection. Have you tried to move objects and tables to the recovery server? Are you using the backup utility in Enterprise Manager or another backup utility?
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/59286

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice