I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► KBSQL ServersMicrosoft SQ...MS SQL 97 / ...   Print This     
  From the December 2015 Issue of Prestwood eMag
 
DBA MS SQL 97 / 2000:
How to transfer an MS SQL database to Prestwood
 
Posted 16 years ago on 11/19/2003 and updated 11/7/2008
Take Away: The preferred technique for transferring an MS SQL database is to do a complete backup and restore.

KB100264



Here are some tips for sending us an MS SQL database. Although you can Export/Import, most MS SQL users simply do a complete backup so we can do a complete restore.

Transferring "Just" the .MDF Database File
If you choose to just "transfer" the .mdf file to us, then follow these steps:

 
1. Detach the database on the source server.
 
2. Create a blank database with the exact same name on the destination database.
 
3. On the destination server, detach the blank database.
 
4. Move the source .MDF file to the destination server.
 
5. On the destination server, attach to the "moved" database .MDF file.

The preferred technique for transferring an MS SQL database is to do a complete backup and restore. Includes some tips for sending us an MS SQL database. Although you can Export/Import, most MS SQL users simply do a complete backup so we can do a complete restore.


Comments

0 Comments.
Share a thought or comment...
 
Write a Comment...
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1207A1
Enter key:
KB Post Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile

 KB Article #100264 Counter
7321
Since 4/2/2008
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,858 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech