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 |
|
JeffS23
Posting Yak Master
212 Posts |
 Posted - 2007-12-27 : 13:32:00
|
| I have SQL 2000 set as my default server - I will be transitioning to SQL 2005 - so have that installed as a seperate named instance on the same box - can I set my SQL 2005 ldf and mdf files to use the same as my SQL 2000 - if possible - will it cause any problems? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-27 : 13:39:17
|
| Are you referring to the default location of the database files?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2007-12-27 : 14:11:11
|
| I have done it once ... didnt give any problems as such .. database restored without any problems |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-12-27 : 21:53:29
|
you want both your SQL 2000 and 2005 to use the same mdf + ldf files ? That will not be possible
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-27 : 22:12:24
|
| >> I have done it once ... didnt give any problems as such How did you do that? I like to learn the trick. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-12-28 : 02:57:16
|
quote:
Originally posted by rmiao
>> I have done it once ... didnt give any problems as such How did you do that? I like to learn the trick.
it worked until the corruption thing started happening..  |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-01-21 : 05:02:46
|
quote]Originally posted by eyechart
quote:
Originally posted by rmiao
>> I have done it once ... didnt give any problems as such How did you do that? I like to learn the trick.
it worked until the corruption thing started happening.. [/quote]If that what makes you happy Barbie ! |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-21 : 10:33:39
|
quote:
Originally posted by sakets_2000If that what makes you happy Barbie !
i don't even know what that means. -ec |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-01-22 : 08:24:50
|
I should have guessed that !quote:
Originally posted by eyechart
quote:
Originally posted by sakets_2000If thats what makes you happy Barbie !
i don't even know what that means. -ec
|
|
|
|
|
|
|
2 Seperate SQL Instances