Post reply

restoring .bak file to new database using T-SQL

  • May 18, 2015 at 3:00 pm

    #1798847

    Glad we were finally able to help you with this issue.

  • May 19, 2015 at 6:15 am

    #1798982

    Thank you for your patience... and I will study the books online and this solution to better understand this and similar issues that will arise in the future... again... thanks!

  • November 29, 2022 at 7:31 am

    #4119350

    Hi

    You can restore SQL .bak file with few simple steps to process the same you will be required SQL Server (As you are using local server) & SQL Server Management Studio (SSMS).

    Please follow the given steps.

    1- Launch your SSMS and connect it to your server.

    2- Right-click the Databases node in Object Explorer and select Restore Database.

    3- Select Device, and then file location in your device.

    4- Select your SQL .bak file

    5- Select OK to close the Select backup devices dialog box.

    6 - Select OK to restore the backup of your database.

    Alternatively, you can run the following Transact-SQL script to restore your database. The path may be different on your computer:

    USE [master];

    GO

    RESTORE DATABASE [SQLTestDB]

    FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\SQLTestDB.bak' WITH FILE = 1, NOUNLOAD, STATS = 5;

    GO

    Thanks

  • November 29, 2022 at 8:12 am

    #4119359

    You do realise this thread is over 7 years old

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • November 29, 2022 at 9:07 am

    #4119379

    Yes, I agree

    But If someone will face this situation again & found this thread, It may help someone.

    Thanks

  • December 5, 2023 at 5:19 am

    This was removed by the editor as SPAM

Viewing 6 posts - 61 through 65 (of 65 total)

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