How To Open Bak File İn Sql Server Management Studio?
-
If you have a database already made and you intend to use it in your Microsoft SQL Server Management Studio (SSMS) program, the process is very simple: to use a file with the .bak extension. A file with a .bak extension provides a lot of convenience to the software developers. Look at the extension files you see in the photo below.
First, the Microsoft SQL Server Management Studio program opens.
Click on the “Object Explorer” panel once. You will see the command “Database” on the incoming screen. Right-click on this command.
Click on the “Restore Database” command once again. The “Select Backup Device” window appears on the screen.
On the screen: Next to the “Specify the backup media and its location for your operation” command, select Backup Media type: “File” and select the “Look in this file” file and click Add.
We see the look file that we selected in the Database section and the name of our database is marked. Before you finish the process, click OK in the box below Restore and click OK.
-
Is there a question here?
-
Nah... no question here. It's a form of semi-helpful spam to get people to go see someone's blog.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Lynn Pettis - Tuesday, February 26, 2019 1:14 PM
There is idea and suggestions about "bak file".
- Jeff Moden - Tuesday, February 26, 2019 2:15 PM
Jeff hello,I don't want to be misunderstood. I removed the link.
- sqlhidir - Tuesday, February 26, 2019 4:59 PM
ah. link is in all your posts. seems to be in your signature.
On a different note backup extension does not need to be .bak. Can be nearly anything we choose.
So this really is just a short demo of how to restore a database backup from a backup file. - sqlhidir - Tuesday, February 26, 2019 4:59 PM
Hi John,
Now that you've explained a bit, especially with your reply to Lynn, I get what you're doing now and owe you an apology. And thank you for trying to help other folks out.On that note, you might want to consider writing an article for this site in the same vein as this post. You can't retire on what they'll pay you but at least they pay and the site does have a huge number of follows. Not only would it help you get your ideas out to a larger audience but it will help you build your brand.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden - Tuesday, February 26, 2019 8:34 PM
Unless you plan to blog very regularly (which is how you build a blog), then I strongly suggest you follow Jeff's advice. Write articles for the site. You'll get to share your knowledge and build your communication skills at the same time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply