Loading ...

Restore your database from BAK file using SQL Server Management Studio 2005 / 2008

Who is online?  0 guests and 0 members
home  »  blogs  »  Hajan Selmani  »  Restore your database from BAK file using SQL Server Management Studio 2005 / 2008

Restore your database from BAK file using SQL Server Management Studio 2005 / 2008

(1)
(7712)
0
/5
Avg: 0/5: (0 votes)

posted 9/1/2010  by Hajan Selmani

In the following blog post, I will try to explain step by step about how to restore your database from BAK (backup) file using SQL Server Management Studio 2005 (or 2008).

This is a STEP BY STEP explanation on how I did restore (the shortest way).

Note: You don't need to have your new database (to which we will do restore) created in advance.

1. Open Microsoft SQL Server Management Studio 2005

2. Connect to the Server

3. You will have your databases

I have created backup from my testDatabase. So, It won't matter if the testDatabase will be there or will be dropped, I have the backup file in C:\backup\myBackup.BAK.

4. Right cilck on Databases (1) and click the Restore Database... (2)

 

5. Write the database name of your new database (1) that you would like the SQL Server Management Studio to create for you (be careful, the name should not exist), then chose the option From device (2) and click the ... button (3) - (see pic bellow)


6. In the new window that will appear, click ADD

7. Then, find the BAK file from your file system, in my case it's in C:\backup\myBackup.BAK (1) and click OK (2)

8. The path to the file will be shown in the next window (1), then click OK (2)

 

9. Then, thick the checkbox as in the following image under 1 (1) and go to Options (2)

10. Then you will see the following screen:

Double click in the first row on the Restore As column

and change the testDatabase to myNewDbName

NOTE: In SQL Server Management Studio 2005, you will need to change the name manually, while in SQL Server Management Studio 2008, it will change the name automatically depending of the name we have previously written as 'myNewDbName' - This is the main place where developers make mistake when trying to restore and errors are generated.

 

than, make the same with the second row, testDatabase_log to myNewDbName_log


11. At the end, just click OK (1). You will see the Progress (2) and the message (3) like in the following screen should pop up.

And, thats it!

 

This complete STEP BY STEP explanation can be also made with the following SQL Script, which is equal to what we did using the SSMS Wizards.

RESTORE DATABASE [myNewDbName] FROM  DISK = N'C:\backup\myBackup.BAK' WITH  FILE = 1,  
MOVE N'testDatabase' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\myNewDbName.mdf',  
MOVE N'testDatabase_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\myNewDbName_log.LDF',  
NOUNLOAD,  STATS = 10
GO


 

 tags: Restore; BAK; SQL Server Management Studio 2005; SQL Server Management Studio 2008; Wizards;

Product Spotlight

ASP.NET Hosting Spotlight
 

Comments (3)

Delete
Andrew
Andrew said:

Worked great. Thank you very much.

12/22/2010
 · 
Comment
 
by
Delete
men's wallets
men's wallets said:

This comment is awaiting moderation.

Hi, I noticed a 3 of your attention-grabbing posted posts and needed to ask if you could be fascinated with reciprocal pages? Workforce have weblog about alexis texas ass! Anyway, in my language, there aren't a lot good supply like this [b][url=http://www.lovesgo.com/pt/casamentos-c7427]mochilas escolares[/url][/b] [b][url=http://www.lovesgo.com/pt/mens-carteiras-c264]carteiras masculinas[/url][/b] Buy online sexy lingerie.lingeriessexy.fr is your best store ligne.Luxury,cheap wholesale price, many colors.<b><a href="http://www.lingeriessexy.fr/en/feminine/maternity-sleepwear-robe-c1478">plus size lingerie</a></b> If you love buying shoes more than anything else; if your wife is a shoe fetish<b><a href="http://www.zapateriaonline.net/en/catalogsearch/Showresult/party-c0-p2">zapatos de fiesta</a></b>, then you must be looking for new places to shop. Nevertheless, almost every city has a good number of shoe stores. However, if you are not in a mood to travel and yet want to indulge in the sin then you can still access to every shoe you can dream of. provide[b][url=http://www.lovesgo.com/es/bodas-c7350]bolsas femininas[/url][/b] [b][url=http://www.lovesgo.com/en/backpacks-c7427]cool backpacks[/url][/b] Professional bridal dresses stores online.Many fashion styles of bridal wedding dresses,bridal gowns are designed for you! Cheap price and best quality. [b][url=http://www.lovesgo.com/victorian-dresses-c269]victorian dresses[/url][/b]It is not only you who can enjoy with the wedding dress up [b][url=http://www.lovesgo.com/en/red-carpet-dresses-c249]red carpet dresses[/url][/b] [b][url=http://www.jtogo.de/c/brautkleider-c433]brautkleider[/url][/b] Professionelle Brautkleidern Stores online unter jtogo.de. Viele Mode-Stile der Braut Brautkleider, Brautkleider sind für Sie geschaffen! Günstige Preise und beste Qualit?t. [b][url=http://www.lovesgo.com/de/schultertasche-c7397]umh?ngetaschen damen[/url][/b] But making a fashion statement isn't just for women [b][url=http://www.lovesgo.com/vintage-c233]vintage wedding dresses[/url][/b] [b][url=http://www.zapateriaonline.net/en/zapateria/sandals-c2453]girls sandals[/url][/b] [b][url=http://www.jtogo.de/c/prom-dresses-c442]abendkleider günstig[/url][/b] Wenn Sie elegant und stilvoll prom Kleider oder Brautjunferkleider müssen, k?nnen jtogo.de bieten Ihnen hier entsprechende M?glichkeiten für jeden Anlass. Besuchen Sie uns online. [b][url=http://www.zapateriaonline.net/en/catalogsearch/Showresult/bridal-shoes-c0-p1]scarpe sposa[/url][/b] Buy Online High-heeled Shoes. Check out the latest collection of High-heeled Shoes.Catch up with the steps of globle fashion.[b][url=http://www.zapateriaonline.net/en/zapateria/high-heeled-shoes-c2457]high heels[/url][/b] [b][url=http://www.zapateriaonline.net/en/zapateria/wedding-shoes-c2523]wedding shoes[/url][/b] with cheap prices,unique styles,personalized designs and high quality which makes you be the most shining [b][url=http://www.zapateriaonline.net/en/zapateria/wedding-shoes-c2523]wedding shoes[/url][/b] [b][url=http://www.zapateriaonline.net/en/zapateria/wedding-shoes-c2523]bridal shoes[/url][/b] [b][url=http://www.zapateriaonline.net/en/zapateria/snow-boots-c2462]snow boots[/url][/b] [b][url=http://www.zapateriaonline.net/en/zapateria/wedding-shoes-c2523]bridal shoes[/url][/b] [b][url=http://www.zapateriaonline.net/en/zapateria/other-sneakers-c2479]shoes with toes[/url][/b] Thisseason we have one of the largest selections of North Face Jackets Online .This includes technical North Face Jackets that are super warm and ideal for the winter and North Face Coats that are light-weight for the summer season too.In addition,our store A plus size corset is larger than a normal size corset, but it should not be too large[b][url=http://www.lingeriessexy.fr/en/feminine/corsets-bustiers-c1496]plus size corsets[/url][/b] Buy online[b][url=http://www.lingeriessexy.fr/en/feminine/panties-c1497]sexy dresses[/url][/b] [b][url=http://www.lingeriessexy.fr/en/feminine/mens-underwear-c891]mens underwear[/url][/b] [b][url=http://www.lingeriessexy.fr/en/feminine/thongs-c1503]thongs for men[/url][/b] from lingeriessexy.fr.com,your exclusive source of body aware designer underwear. [b][url=http://www.jtogo.de/c/prom-dresses-c442]abendkleider günstig[/url][/b] Wenn Sie elegant und stilvoll prom Kleider oder Brautjunferkleider müssen, k?nnen jtogo.de bieten Ihnen hier entsprechende M?glichkeiten für jeden Anlass. Besuchen Sie uns online. [b][url=http://www.jtogo.de/c/brautkleider-c433]brautkleider[/url][/b] Professionelle Brautkleidern Stores online unter jtogo.de. Viele Mode-Stile der Braut Brautkleider, Brautkleider sind für Sie geschaffen! Günstige Preise und beste Qualit?t. [b][url=http://www.jtogo.de/c/cocktail-kleid-c443]cocktailkleider[/url][/b] Kaufen jede Art von Cocktail-Kleidern für den besten Preis nur in unserem Online-jtogo.de. Cocktail-Kleider sind immer in jedem Stil, alle Gr??en und für jeden Preis zur Verfügung. [b][url=http://www.lingeriessexy.fr/en/feminine/stockings-thigh-highs-c1492]knee high socks[/url][/b] [b][url=http://www.lingeriessexy.fr/en/feminine/stockings-thigh-highs-c1492]thigh high socks[/url][/b]Ladies footwear is one of the most important fashion accessory used by women [b][url=http://www.lingeriessexy.fr/en/feminine/stockings-thigh-highs-c1492]knee socks[/url][/b] [b][url=http://www.jtogo.de/c/abendkleider-c440]abendkleider[/url][/b] Holen Sie sich die neueste Damenmode, suchen lange Abendkleider, plus size Abendkleider und günstige Abendkleider, ist jtogo.de Ihre erste Wahl. [b][url=http://www.clothinggo.com/]clothes shops[/url][/b] <b><a href="http://www.clothinggo.com/pt/blazers-e-jaquetas-c861">casacos femininos</a></b> <b><a href="http://wholesale.wholesale-electronics-bulk.com/wholesale/mobile-phone-telephone-accessories-c2">cell phone accessories wholesale</a></b> <b><a href="http://www.zapateriaonline.net/it/">scarpe on line</a></b> <b><a href="http://www.lovesgo.com/en/red-carpet-dresses-c249">red carpet dresses</a></b> <b><a href="http://www.lingeriessexy.fr/en/feminine/panties-c1497">sexy dresses</a></b> <b><a href="http://www.jtogo.de/c/kleider-f%C3%BCr-besondere-anl%C3%A4sse-c280">abschlussballkleider</a></b> Online shopping is perhaps the perfect suggestion when shopping [b][url=http://www.lovesgo.com/es/weddings/special-occasion-dress]vestidos longos[/url][/b] [b][url=http://www.lovesgo.com/short-c234]beach wedding dresses[/url][/b] [b][url=http://www.lovesgo.com/es/weddings/special-occasion-dress/graduation-dresses]vestidos de graduacion cortos[/url][/b] These are really great gifts, but sometimes, you can hardly find ones that will fit to your limited budget. So, here are some ideas if you really opt to give <b><a href="http://www.clothinggo.com/childrens-clothing-shoes-c1731">cheap baby clothes</a></b> Moreover[b][url=http://www.zapateriaonline.net/zapateria/otros-c2522]zapatos 2012[/url][/b] <a href="http://www.lovesgo.com/rings-c39">rings</a> [b][url=http://wholesale.wholesale-electronics-bulk.com/wholesale/mobile-phones-c10]wholesale cell phones[/url][/b] Buying [b][url=http://wholesale.wholesale-electronics-bulk.com/wholesale/mobile-phone-telephone-accessories-c2]cell phone accessories wholesale[/url][/b] has its rewards. When you buy in bulk, you usually get discounts.[b][url=http://wholesale.wholesale-electronics-bulk.com/wholesale/batteries-c139]wholesale batteries[/url][/b] [b][url=http://wholesale.chinawholesaleclothing.net/wholesale/shirts-c5]wholesale shirts[/url][/b] [b][url=http://wholesale.chinawholesaleclothing.net/]cheap wholesale clothing[/url][/b] [url=http://wholesale.chinawholesaleclothing.net/]wholesale clothing[/url][/b] <a href="http://www.lovesgo.com/earrings-c51">Stainless Steel Earrings</a> A deeper look will tell you that the websites carry either very little or almost no overhead costs: <a href="http://www.lovesgo.com/jewelry-suits-c53">jewelry-suits</a> [b][url=http://www.lovesgo.com/it/weddings/wedding-dresses]vestiti da sposa[/url][/b] [b][url=http://www.lovesgo.com/es/weddings/special-occasion-dress]vestidos longos[/url][/b] [b][url=http://www.lovesgo.com/short-c234]beach wedding dresses[/url][/b] [b][url=http://www.lingeriessexy.fr/en/feminine/sexy-lingerie-c922]sexy lingerie[/url][/b]Only skinny girls can wear fashionable clothe [b][url=http://www.lingeriessexy.fr/en/feminine/maternity-sleepwear-robe-c1478]plus size lingerie[/url][/b] Fashionable maternity clothes especially dresses,plus size lingerie make you to be sexy maternity. [b][url=http://www.lingeriessexy.fr/en/feminine/panties-c1497]sexy dresses[/url][/b] [b][url=http://www.lingeriessexy.fr/en/feminine/mens-underwear-c891]mens underwear[/url][/b] This includes technical North Face Jackets that are super warm and ideal for the winter and North Face Coats that are light-weight for the summer season too.In addition,our store [b][url=http://www.clothinggo.com/es/vestidos-c1666]vestir princesas[/url][/b] [b]rl=http://wholesale.chinawholesaleclothing.net/]cheap wholesale clothing[/url][/b] [b][url=http://wholesale.chinawholesaleclothing.net/wholesale/jeans-c148]wholesale jeans[/url][/b]The Antoine Equation is based upon experimental vapor pressures measured over a set temperature range. [b][url=http://wholesale.chinawholesaleclothing.net/wholesale/costumes-accessories-c241]wholesale costumes[/url][/b][b][url=http://wholesale.chinawholesaleclothing.net/wholesale/dresses-c14]wholesale dress[/url][/b] [b][url=http://www.lingeriessexy.fr/en/feminine/undershirts-c1501]gymnastic leotards[/url][/b] [b][url=http://www.lingeriessexy.fr/it/feminine/mutandine-c1497]super tanga[/url][/b] Lingerie bridal showers are known for being over-the-top events where bashful friends of a bride-to-be may not want to set foot. Contrary to popular belief, though, there are a number of games that both fit the theme of a lingerie bridal shower and can fit[b][url=http://www.lingeriessexy.fr/en/feminine/corsets-bustiers-c1496]plus size corsets[/url][/b] the comfort level of any crowd[b][url=http://www.lingeriessexy.fr/en/feminine/bras-bra-sets-c1494]backless bra[/url][/b], from the timid[b][url=http://www.lingeriessexy.fr/en/feminine/bras-bra-sets-c1494]cheap bras[/url][/b] to those who appreciate risqué humor. [b][url=http://www.clothinggo.com/pt/sweater-set-cabe%C3%A7a-c1815]agasalhos esportivos[/url][/b] Buy online[b][url=http://www.clothinggo.com/pt/windbreaker-c1663]casacos femininos[/url][/b] [b][url=http://www.clothinggo.com/de/baumwolle-gepolsterte-kleidung-c1640]wintermantel damen[/url][/b] Latest Fashion Trends[b][url=http://www.clothinggo.com/suits-c874]cheap suits[/url][/b]And that's the reason why they are so much popular among women. Discover the best deals on a Swiss Gear Computer Backpack ,[b][url=http://www.lovesgo.com/mens-wallets-c264]men's wallets[/url][/b]or [b][url=http://www.lovesgo.com/en/backpacks-c7427]cool backpacks[/url][/b] The Suit Rack is committed to deliverying Fine Men's Clothing [b][url=http://www.clothinggo.com/es/vestido-de-dama-c1632]faldas elegantes[/url][/b]with Exceptional Service. We carry Business Suits,[b][url=http://www.clothinggo.com/jeans-c894]suits for men[/url][/b] Men's Linen Suits, Blazers, Sportcoats, Men's Pants and Trousers[b][url=http://wholesale.chinawholesaleclothing.net/]wholesale clothing suppliers[/url][/b] [b][url=http://wholesale.chinawholesaleclothing.net/wholesale/dresses-c14]wholesale dresses[/url][/b] [b][url=http://wholesale.chinawholesaleclothing.net/wholesale/wedding-dresses-c198]wholesale wedding dresses[/url][/b] [b][url=http://www.clothinggo.com/cashmere-coats-c1649]overcoat[/url][/b]Take advantage of this opportunity and dress-up like a Diva for winters. Have Fun!!
4/13/2012
 · 
Comment
 
by
Delete
agasalhos esportivos
agasalhos esportivos said:

This comment is awaiting moderation.

If you love buying shoes more than anything else; if your wife is a shoe fetish<b><a href="http://www.zapateriaonline.net/en/catalogsearch/Showresult/party-c0-p2">zapatos de fiesta</a></b>, then you must be looking for new places to shop. Nevertheless, almost every city has a good number of shoe stores. However, if you are not in a mood to travel and yet want to indulge in the sin then you can still access to every shoe you can dream of. <b><a href="http://www.lovesgo.com/pt/casamentos-c7427">mochilas escolares</a></b> <b><a href="http://www.lovesgo.com/pt/mens-carteiras-c264">carteiras masculinas</a></b> <b><a href="http://www.lovesgo.com/de/damen-geldb%C3%B6rsen-c262">geldb?rsen damen</a></b> <b><a href="http://www.lovesgo.com/mens-wallets-c264">men's wallets</a></b> Thisseason we have one of the largest selections of North Face Jackets Online .This includes technical North Face Jackets that are super warm and ideal for the winter and North Face Coats that are light-weight for the summer season too.In addition,our store <b><a href="http://www.lingeriessexy.fr/en/feminine/undershirts-c1501">gymnastic leotards</a></b> <b><a href="http://www.lingeriessexy.fr/it/feminine/mutandine-c1497">super tanga</a></b> <b><a href="http://www.lingeriessexy.fr/en/feminine/corsets-bustiers-c1496">plus size corsets</a></b> <b><a href="http://www.lingeriessexy.fr/en/feminine/women%E2%80%99s-intimates-c866">womens underwear</a></b> <b><a href="http://www.lingeriessexy.fr/en/feminine/women%E2%80%99s-intimates-c866">ladies underwear</a></b> <b><a href="http://wholesale.wholesale-electronics-bulk.com/wholesale/batteries- c139">wholesale batteries</a></b> <b><a href="http://www.clothinggo.com/es/faldas-c1646">bajo faldas</a></b> <b><a href="http://www.clothinggo.com/es/vestidos-c1666">vestir princesas</a></b> <b><a href="http://www.clothinggo.com/pt/sweater-set-cabe%C3%A7a-c1815">agasalhos esportivos</a></b>
4/13/2012
 · 
Comment
 
by
Add a new comment
  • Name:*
  • Email:*
  • Website:
Type the characters you see in the image *

Confirm

Latest community blog posts

  • jQuery Tools Tabs: Tab index lost on postback
    yesterday by Raghav Khunger
    A person on the forums was struggling with jQuery tools tabs index issue on postback. On clicking the tabs and doing some postback the selected tab index was getting lost. Below is the solution on how to retaing the previous selected index which was there before postback. Complete Source: <%@ Pag...
  • jQuery Tools Tabs: Set initial selected index by default
    yesterday by Raghav Khunger
    I was working with jQuery tools tabs today and I had to set the initial index of tab selected by default. The solution is to set initialindex property in the options. Source: $("ul.tabs").tabs("div.panes > div", { initialIndex: 1 }) ; Complete code to test above: <html> <head> <tit...
  • ASP.NET: Get formauthentication cookie and get the data present in it
    3 days ago by Raghav Khunger
    A person asked me today how to get form authentication cookie and get the data present in it. I decided to write a short blog on it. Formauthentication cookie is saved with the name which we can get via FormsAuthentication.FormsCookieName property. The key here is to get the cookie via this name and...
  • ASP.NET: Form authentication timeout in web.config overriding the manual ticket timeout
    13 days ago by Raghav Khunger
    While working with one of the sample application I noticed that form authentication timeout in web.config was overriding the manual ticket's (which we created via code) timeout. Below is the code which was written in the application: var ticket = new FormsAuthenticationTicket(1, "UserName", DateTime...
  • jQuery: Set cursor position in textbox
    4/13/2012 by Raghav Khunger
    In this blog I will show how to select a range of characters in textbox with jquery. In my demo I have used one textbox and one button. On click of button arange of characters in textbox will be selected. Below is the sample code: <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="ser...

Hajan Selmani's latest blog posts

Product Spotlight

ASP.NET Hosting Spotlight

 

Quick Vote

What kind of email newsletter would you prefer to receive from CodeAsp.Net?