Saving DB's

I need to format and dont want to lose my db's and all.
I recall having to restore them when I began this whole process but Im not sure how to save them properly so once I finish the format and install I can just restore them and have them as they are currently.

Quote:

Originally Posted by IncognitoOne I need to format and dont want to lose my db's and all. I recall having to restore them when I began this whole process but Im not sure how to save them properly so once I finish the format and install I can just restore them and have them as they are currently.

I can help you tomorrow if im back Home if you want.
Also can show you Step for Step how you can save a DB ^^

If you make it asap here:

[Only registered and activated users can see links. Click Here To Register...]

Simply back up each one you want to save using SQL Server Management Studio.

[Only registered and activated users can see links. Click Here To Register...]

By default the tool plops the backups here:

C:\Program Files\Microsoft SQL Server\<DB INSTANCE NAME>\MSSQL\Backup
C:\Program Files (x86)\Microsoft SQL Server\<DB INSTANCE NAME>\MSSQL\Backup
(depends on if you installed 64-bit or 32-bit sql server)

Copy them out to someplace safe.

When you've reinstalled Windows and MSSQL Server, restore each database using SQL Server Management Studio. This part is niggly and unnecessarily tedious (thanks Microsoft).

But at the end of the day you will have your databases just as you left them before reformatting.

Thanks Joe thats exactly what I want to do and Rito if I have any issues I'll harass you , you know that :P

Now to finish this stupid iso image