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 |
|
MARINOS
Starting Member
13 Posts |
 Posted - 2007-12-15 : 13:00:57
|
| how mutch time is spend to detattach and attach an database 100GB from sql 2000 to sql 2005??? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-12-15 : 13:03:30
|
| Won't take very long , do you need to transfer the files across the network?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
MARINOS
Starting Member
13 Posts |
Posted - 2007-12-15 : 13:06:35
|
| Yes i will transfer the database from old server to new one and then a i will attach te database in new sqlserver 2005. This prosedures how mutch time they will take? PS the database size is 100GB |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-15 : 23:02:07
|
| Detach/attach is quick, but copy 100gb file takes a while. |
|
|
|
|
|
|
From 2000 to 2005