×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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!

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

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Rebuilding SQL Server

Rebuilding SQL Server

Rebuilding SQL Server

(OP)
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?

RE: Rebuilding SQL Server

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..

RE: Rebuilding SQL Server

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"

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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! Already a Member? Login


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