Post reply

BAckup and restoration

  • April 13, 2011 at 3:27 pm

    #236693

    Hi everyone

    I have one database 'Test'

    I have taken full backup of 'test' database now i want to restore it on same database without overwrite option but i am unable to do that

    Is it possible?

  • April 15, 2011 at 7:49 am

    #1312150

    Yes you can, but you have to give a different name to your restored DB.

    RESTORE DATABASE [TEST_restored] FROM DISK = N'K:\TEST.bak' WITH FILE = 1,

    MOVE N'modeldev' TO N'K:\MSSQL\DATA\TEST_restored.mdf',

    MOVE N'modellog' TO N'K:\MSSQL\DATA\TEST_restored_1.ldf', NOUNLOAD, STATS = 10

    GO

    QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809

  • April 15, 2011 at 12:22 pm

    #1312298

    Thanks a lot... for your answer

    let me try using this way.

Viewing 3 posts - 1 through 2 (of 2 total)

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