Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vivekjain43
Starting Member
8 Posts |
 Posted - 2006-04-11 : 04:18:31
|
| Hi, I have SQL Server 2000 and I need to re-install SQL Server. Since I have couple of databases created, will it suffice if I take a copy of the data folder. If yes, if I over-write the data folder to the new installation, will the new SQL Server has those db's? Thanks |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-11 : 04:20:27
|
| Just take a backup of the databases and restore on the new instances of SQL Server.. This should fine i guesss..If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
vivekjain43
Starting Member
8 Posts |
Posted - 2006-04-11 : 04:23:54
|
| Thanks for your reply. Actually I am having some problem with connecting to the SQL Server, and thats the reason I am reinstalling. Since I am unable to access the databases using the Enterprise Manager, I wouldnt be able to take a back up. Kindly suggest.Thanks |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-11 : 04:25:33
|
| it pays to have options just in case...1. backup the databases2. restore each one to verify3. detach the databases4. reattach them 5. copy the backup file and detached db files onto your new server6. attach the db files if attach fails, then you can do the restoreHTH--------------------keeping it simple... |
|
|
|
vivekjain43
Starting Member
8 Posts |
Posted - 2006-04-11 : 04:29:59
|
| But then, for me to take a backup, I need to do so using the Enterprise Manager, but the problem is I am unable to connect to the SQL Server using the Enterprise manager, and thats the reason I am not able to take a back up. Is there any other way that you can suggest.Thanks |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-11 : 04:37:12
|
| Then you can use QA for the taking the backup.. Look out for the syntax of taking backup in Book Online ..If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
|
|
|
DB Files