1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

how can we use sqlwebrestore

Discussion in 'Plesk for Windows - 8.x and Older' started by hamed23100, Mar 9, 2006.

  1. hamed23100

    hamed23100 Regular Pleskian

    25
    57%
    Joined:
    Mar 9, 2006
    Messages:
    109
    Likes Received:
    0
    i need to know how can i restore sql server databases to websites. is there any special software or webpage to do this? i have plesk power pack.
     
  2. OlegB

    OlegB Guest

    0
     
    What kind of databases you want to get restored:
    MSSQL, MySQL?
    What kind of backup do you have?
     
  3. hamed23100

    hamed23100 Regular Pleskian

    25
    57%
    Joined:
    Mar 9, 2006
    Messages:
    109
    Likes Received:
    0
  4. OlegB

    OlegB Guest

    0
     
    Unfortunately this link is not working.
    But I can give a tip. If you have a separate MSSQL database backup you restore into Plesk.
    You need just create this database and DB user within Plesk and restore content using osql.exe tool.

    C:\Program Files\SWsoft\Plesk\admin\bin>osql -E
    1> restore database mydb from disk = "c:\mydb.mssql.bkp" with replace;
    2> go
    Processed 80 pages for database 'mydb', file 'mydb' on file 1.
    Processed 1 pages for database 'mydb', file 'mydb_log' on file 1.
    RESTORE DATABASE successfully processed 81 pages in 0.047 seconds (13.987 MB/sec).
    1>quit

    Something like that.
     
  5. hamed23100

    hamed23100 Regular Pleskian

    25
    57%
    Joined:
    Mar 9, 2006
    Messages:
    109
    Likes Received:
    0
Loading...