Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...An excellent site which has quite possibly prevented me from having a mental/nervous breakdown..."

Geography

Where in the world do Tek-Tips members come from?
Jesus (MIS)
22 Feb 99 0:03
I am preparing to wipe and reinstall our SQL server. Although, once it's wiped and NT/SQL are reinstalled, how do you go about getting the SQL tables and databases back into it?
Warcorp (Staff)
22 Feb 99 17:13
a couple of ways here to do this. First is to make a backup of the data using an sql agent on backup package (Arcserve, etc.). This will allow you to make backup of the data in place and will allow you to restore it to a newly installed SQL server. The second was I know is to make a database dump using the SQL manager, making sure you do a complete dump of data and transactions. Actually make a couple of them just to be sure you have a copy of the data. To be completely sure, make a full backup of the server itself, with SQL services stopped, just in case (You can't have too many backups of your data here). You also want to document information from the database such as master db size and the databse device names and sizes log names etc. Everything that has been customized to the actual database. Make sure you can restore a copy of the dumpfile to the server and once you have sql re-installed and the devices and databases recreated, restore the data to the appropriate database name using database manager.

Either way you do it, make lots and lots of backups, you can NEVER be too carefull...Trust technology but always protect you data..
Graeme (MIS)
27 Feb 99 12:55
Make sure that you back up and dump the master database last, prior to destroying the server and preparing for re-install. "Master is and master it will be"

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close