restoring .bak file to new database using T-SQL

Question

Post reply

restoring .bak file to new database using T-SQL

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

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

DaveBriCam SSCarpal Tunnel Points: 4298 More actions · Answer 2

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!

Techno-Umesh Grasshopper Points: 18 More actions · Answer 3

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

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

You do realise this thread is over 7 years old

This reply was modified 1 year, 11 months ago by Perry Whittle.

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

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

Techno-Umesh Grasshopper Points: 18 More actions · Answer 5

Yes, I agree

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

Thanks