Post reply

Restore Database Syntax

  • July 1, 2016 at 2:45 am

    #323665

    What is wrong with the following syntax?

    RESTORE DATABASEPrismDataBilling

    FROM DISK = 'G:\MSSQL11.MSSQLSERVER\MSSQL\Backup\PrismData\PrismData_backup_2016_06_26_130000_9108635.bak'

    WITH MOVE 'PrismData_Data' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Data.mdf',

    MOVE PrismData_FG2_0 TO 'D:\PrismDataBilling.ndf',

    MOVE PrismData_FG2_1 TO' D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Indices_0.ndf',

    MOVE PrismData_FG1_0 TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_FG1_0.ndf',

    MOVE PrismData_FG1_1 TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismData_FG1_1.ndf',

    MOVE PrismData_Log TO 'F:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Log.ldf'

    Msg 155, Level 15, State 1, Line 2

    'DATABASEPrismDataBilling' is not a recognized RESTORE option.

    Msg 3

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 1, 2016 at 2:54 am

    #1888020

    I try:

    RESTORE DATABASE PrismDataBillingTest

    FROM DISK = 'G:\MSSQL11.MSSQLSERVER\MSSQL\Backup\PrismData\PrismData_backup_2016_06_26_130000_9108635.bak'

    And I get this?

    Msg 3154, Level 16, State 4, Line 2

    The backup set holds a backup of a database other than the existing 'PrismDataBillingTest' database.

    Msg 3013, Level 16, State 1, Line 2

    RESTORE DATABASE is terminating abnormally.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 1, 2016 at 3:01 am

    #1888021

    RESTORE DATABASE PrismDataBillingTest

    FROM DISK = 'G:\MSSQL11.MSSQLSERVER\MSSQL\Backup\PrismData\PrismData_backup_2016_06_26_130000_9108635.bak'

    WITH MOVE 'PrismData_Data' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Data.mdf',

    MOVE PrismData_FG2_0 TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBilling_Indices_0.ndf',

    MOVE PrismData_FG2_1 TO' D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Indices_0.ndf',

    MOVE PrismData_FG1_0 TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_FG1_0.ndf',

    MOVE PrismData_FG1_1 TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismData_FG1_1.ndf',

    MOVE PrismData_Log TO 'F:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Log.ldf'

    Msg 102, Level 15, State 1, Line 4

    Incorrect syntax near 'PrismData_FG2_0'.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 1, 2016 at 3:04 am

    #1888022

    RESTORE DATABASE PrismDataBillingTest

    FROM DISK = 'G:\MSSQL11.MSSQLSERVER\MSSQL\Backup\PrismData\PrismData_backup_2016_06_26_130000_9108635.bak'

    WITH MOVE 'PrismData_Data' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Data.mdf',

    MOVE 'PrismData_FG2_0'TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBilling_Indices_0.ndf',

    MOVE 'PrismData_FG2_1' TO' D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Indices_0.ndf',

    MOVE 'PrismData_FG1_0' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_FG1_0.ndf',

    MOVE 'PrismData_FG1_1' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismData_FG1_1.ndf',

    MOVE 'PrismData_Log' TO 'F:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Log.ldf'

    Msg 3154, Level 16, State 4, Line 2

    The backup set holds a backup of a database other than the existing 'PrismDataBillingTest' database.

    Msg 3013, Level 16, State 1, Line 2

    RESTORE DATABASE is terminating abnormally.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 1, 2016 at 3:14 am

    #1888026

    Closing Post moving to new

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 1, 2016 at 4:16 am

    #1888035

    No further replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1798979-3739-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply