IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

January 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 = P1164A1
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
7087
Since 4/2/2008
-
   Contact Us!
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


Go ahead!   Use Us! Call: 916-726-5675 


©1995-2019 Prestwood IT Solutions.   [Security & Privacy]