Main Menu

Migrating/Moving database(s) across SQL Servers PDF Print E-mail

 

Following are the steps to be followed before migrating/moving a database 

 

1) Take a backup of the source database and save it in a shared folder in the corresponding source server.

 

 

2) Copy the backup file from the share folder of the source server into the destination server. 

 

3) Take a backup of the users in the source database.  How to transfer logins & passwords for a particular database is shown in the below link

  http://www.sqlserver.in/index.php/administration/51-database-migration/100-how-to-transfer-logins-and-the-passwords-between-sql-servers.html  

 

4) Once the scripting of the users in the source database is over restore the source database into the destination server.

 

 

5) Once the restoration is complete apply the login script that has been generated in the step 3. 

 

6) This step would ensure that all the original logins are maintained in the destination database even after restoration.

Comments (31)
  • |96.46.11.xxx |2011-06-30 06:22:27 Windows 7 Activation  - Windows 7 Activation
    chenweiliiPod,Windows 7 Ultimate Activation Key, some of you think this is the equivalent of wearing last season’s shoes.; Zune users have been quick to point out that the Zune plays xBox games,Windows 7 Key, and that the hippest game the video iPod has is Sudoku (which,Windows 7 Home Premium Activation, ok - I love).; And while my iPod usually does make me feel hip,Office 2010 Keygen, the fact that I can’t play downloaded digital music and audio books from the public library on my iPod (so I sit at the coffee shop with my white headphones plugged into my laptop) does make me feel a little… um... dumb.Windows 7 Professional, Scoble agrees with me that the iPod is cooler,Office 2010, but since he was born in the year 1965, I suppose it’s possible that;he's also too old to understand the merits of music swapping.And then the “You are too old to understand” insults followed with comments on my Google post.Readers were quick to point out that in the world of Facebook and MySpace, fillin...
    ReplyQuote
  • |204.152.211.xxx |2011-07-26 07:31:35 Jordan Retro 8  - air jordan 1 shoes
    world Jordan Retro 9famous Jordan shoes or boots created from modern australia raw supplies Jordan Retro 10obtainable in black, chestnut, grey, chocolate, rose, pink.simply butJordan Retro 11 that fashionable.Recently, my friend bought a pair of modern australia merino sheepskin Jordan Retro 12 from specialty shop, genuinely fantastic feeling, she couldn¡¯t wait any much more to wait me,Jordan Retro 13and recommend me to obtain one as well, needless to say I know much more aboutJordan Retro 14, I¡¯m Jordan shoes or boots fans, the income I get from Jordan Retro 15 countless,just pursuing checklist several principal income of Jordan Retro 16. help for Jordan shoes or boots selling with several years, in condition you however odd aboutAir Jordan 16.5, you need to regret no to own recognized Jordan shoes or boots before!Wearing snow boots action just abating and comfortable, Team Jordan Retro 17in accession alluring and pretty, suggestions regarding how to gather Jordan Retro 18 Auc...
    ReplyQuote
  • |204.152.211.xxx |2011-07-29 02:41:31 Authentic Jordans Cheap
    When you choice the sneakers, you are prone to observe some important points. The 1st too as most significant one is its style, Authentic Jordans Cheap can it be really trendy and stylish. ticket Jordan shoes is offered in the wide assortment of colors as well as in add-on they are cheap rare jordans mixed and matched to produce a alternatively funky shoe. Jordan Retro shoes that could nicely be found within rear authentic air jordan shoes outdoors of your shoes offers it an borders that folks love. The general seem outdoors of your shoe is fairly buy air jordan 10 retro good too as designers do an superb occupation on this department. ticket Jordan one is basically a legendary design with various coloring collocations to total all you'll need and imagination. Authentic jordan retro 13 what is more, we also Air Jordans 6 Rings Release Dates provide you with ticket Jordan 2010, ticket Jordan 3, ticket max 2009, ticket max the year 2010 and some a huge amount of other types ticket Jor...
    ReplyQuote
  • |204.152.211.xxx |2011-08-05 01:43:13 Retro Jordan Shoes outlet  - Retro Jordan Shoes outlet
    Nike Air Jordan 1 is the most retroed sneaker ever in the world, and it has a special link with Michael Jordan's career and personality.
    Authentic Louis VuittonIn 1984, a lean shooting lookout from the Dean Smith-led UNC Tar Heels was special third general by the Jordans for sale Chicago Bulls in the NBA Draft. The daring red and jet black was in unity with his surly Air Jordans 1 Retro
    bearing and mild arrogance, but it was a beguiling, boyish smirk that required the league's collective protect down,
    cheapest/cheap louis vuitton handbags departure it vulnerable to damage from any vantage intention. It was too recent by the time the league figured out who Michael Jordan genuinely was, and it rewarded greatly; six
    Air Jordans 18 Retro
    NBA Championships,Authentic LV Hats ten stretch scoring titles in stuffed seasons, five MVP trophies,louis vuitton jeans mens and shelves satiated of other trophies were conceded to one man who bent an unreasonable ordinary for NBA players both duri...
    ReplyQuote
  • |205.209.140.xxx |2011-08-17 00:45:19 uggs sale  - uggs sale
    By all means, they look dangerously comfy,uggs sale, that I wouldn’t be surprised if you caught me accidentally walking down to belstaff jacket. Even so, I am feeling stress-fully torn between my belstaff jackets for comfort and their link to my Grandmother’s ugg canada. Surely, if I pop these on it doesn’t mean I’ve crossed the line between stylish and uggs sale? As long as Countryfile isn’t on that ugg canada.Perhaps it’s just my own irrational fear of picturing these slippers with ugg classic tall? If, however, these luxurious bailey button ugg were teamed with your favourite check pyjama trousers and an oversized t-shirt ugg bailey button, and accessorized with some bailey button uggs then I reckon we’d have an indoor-shoe winner.clw816
    ReplyQuote
  • |205.209.140.xxx |2011-08-17 08:09:14 uggs sale  - uggs sale
    By all means, they look dangerously comfy,uggs sale, that I wouldn’t be surprised if you caught me accidentally walking down to belstaff jacket. Even so, I am feeling stress-fully torn between my belstaff jackets for comfort and their link to my Grandmother’s ugg canada. Surely, if I pop these on it doesn’t mean I’ve crossed the line between stylish and uggs sale? As long as Countryfile isn’t on that ugg canada.Perhaps it’s just my own irrational fear of picturing these slippers with ugg classic tall? If, however, these luxurious bailey button ugg were teamed with your favourite check pyjama trousers and an oversized t-shirt ugg bailey button, and accessorized with some bailey button uggs then I reckon we’d have an indoor-shoe winner.clw817
    ReplyQuote
  • |205.209.143.xxx |2011-08-24 06:23:47 ugg boots sale  - ugg boots sale
    Located in Canada,we provide you with best quality luxurious ugg boots sale. belstaff jackets are selling all around the globe. Choose from our belstaff jacket,and Lace Up boots as well as our enormously popular uggs canada. Kids and baby boots are also available, as well as slippers and scuffs and our uggs canada range and Desert boots. To complement our ugg boots canada we also offer top quality Pashmina shawls. Don't forget to visit our specials page and grab yourself a ugg classic tall boots!At ugg bailey button you will not only receive the best quality products, but highly competitive prices and excellent customer service. If you can't find what you are looking for or have questions on any of our bailey button uggs, please visit uggs bailey button or contact us for more information.clw824
    ReplyQuote
  • |74.125.112.xxx |2011-12-15 03:38:40 cheap oakley sunglasses
    ZTCDJSSLZSBDA
    Why do people love ugg boots
    Big, clunky soles or flat soles, dropped animal skin wares or milky-smooth animal skin wares, actual sheepskin or an imitation, speedy, high, or somewhere in between,

    Ugg Classic Short are the “in” issue to have in your clothes storage space this year or so. And

    you're definite to divulge a couple that matches your budget.
    ReplyQuote
  • |221.150.177.xxx |2011-12-16 03:18:38 watches uk
    Please remember that vintage watches have survived for many decades by being treated Romance God created the brand since 1988,

    replica watchesthe company, registered in 102 countries around the world omega seamaster ladies

    watches,jewelry brand,watches onlinemerchandise exports to 70 countries, is a specialized manufacturer

    of watches and jewelry. Romance of God in 1998 to become a global brand, replica rolex
    hire famous Swiss designer Wolfgang Jonsson program development of brand identity company logos,tiffany jewelry

    uniform color. Romance God omega seamaster quartz watches Korea Co.,Tiffany Ltd. has become the leading

    companies in the industry, rings onlinethe reputation is well known South Korean brand abroad. God watches Co.

    Tiffany ringsLtd. has always been committed to technological innovation and excellence in quality romantic

    and fashion capture,jewellery shopfashion jewelry has become a world dedicated to business goals and

    tireless efforts.
    ReplyQuote
Write comment
Your Contact Details:
Comment:
[b] [i] [u] [url] [quote] [code] [img]   
:D:angry::angry-red::evil::idea::love::x:no-comments::ooo::pirate::?::(
:sleep::););)):0
Security
Please input the anti-spam code that you can read in the image.
Next >
 
Copyright 2009 SQL Server.in, Powered by Joomla!; Joomla templates by SG web hosting