Results 1 to 2 of 2

Thread: Restore Help Please

  1. 11-14-2002, 10:02 PM #1
    new_user
    new_user is offline Registered User
    Join Date
    Oct 2002
    Posts
    16

    Restore Help Please

    I'm trying to run this script file on a one of my SQL Server and it keep says, error at line 3. Can anybody please look at it and advice, what wrong I'm doing.

    To tell what i'm trying to achieve is: I'm trying to load this db on one of my test server in a standby mode with the with replace command. Its not working. Any help will be greatly appreciated.

    The command:
    -------------

    RESTORE DATABASE Test FROM DISK = 'd:\CUSMS1.DMP'
    with replace,
    with standby = 'd:\test.ldf',
    MOVE 'cusmsdbData' TO 'd:\test111.MDF',
    MOVE 'cusmsdb_log' TO 'd:\test11112.LDF'
    Reply With Quote Reply With Quote
  2. 11-14-2002, 11:44 PM #2
    Stephen
    Stephen is offline Registered User
    Join Date
    Sep 2002
    Posts
    169
    get rid of the second 'WITH'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules