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

Unable to restore database.

Discussion in 'Plesk for Windows - 8.x and Older' started by jansiem, Sep 22, 2008.

  1. jansiem

    jansiem Guest

    0
     
    Unable to restore database 'vwmssql8155ff282f9ab048d6d24e50fbc': 'UNLIMITED' is not a recognized CREATE/ALTER DATABASE option.


    Restoring to a new plesk instalation. from 8.6 => 8.6


    Anny sugestions.
     
  2. prince

    prince Regular Pleskian

    24
    53%
    Joined:
    Aug 16, 2006
    Messages:
    166
    Likes Received:
    0
    u can try manual database restore
     
  3. jansiem

    jansiem Guest

    0
     
    yes, but i would be more fun to do it the easy way.

    thanks,
     
  4. tomoiaga

    tomoiaga Guest

    0
     
    Hello,

    Can anyone please fix this.
    Problem description:
    Plesk tries to create the database with the following command:

    `CREATE DATABASE [dbname] ON (NAME = N'dbname', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\dbname.mdf' ,UNLIMITED, FILEGROWTH = 10%) LOG ON (NAME = N'dbname_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\dbname_log.LDF' ,UNLIMITED, FILEGROWTH = 10%)`

    And the UNLIMITED above should have been: maxsize=UNLIMITED, not just UNLIMITED according to MSDN.
     
  5. jansiem

    jansiem Guest

    0
     
    I have found the solution to be changing the Edition (from Express to standard in my case)
    Have fun
     
  6. tomoiaga

    tomoiaga Guest

    0
     
    hello Jansiem, thank you for the answer. I have SQL 2008 WEB (I know, they did not posted anywhere that they support SQL 2008, but it seems a simple problem to fix).

    Also there seems to be a problem with hmail 4.4.1 related to: "In hMailServer 4.3, COM clients must call the Authenticate() function on the hMailServer.Application object prior to accessing any other function in the API. This change was made to increase the security of the hMailServer COM API"

    4.4.1 is supported (at least they say they do)

    There are also some DNS problems switching to BIND from WIN 2003 to WIN 2008 with MS DNS.
     
Loading...