April 7, 2009 at 12:33 pm
Hi,
I am a newbie amd need to know how to look at a setup. The machine has SQL SERVER running on C in program files and on external F-SAN drive in program files. There is app making resuets to the SQL install on c.
Now I must move the machine and will lose my my F drive. I did not setup this current setup and do not know the reprocussions of losing my F drive. How do I know if its not RAIDed to the SQL SERVER on C? Is there a way to know other than just looking at the files and directory structure to know how the SQL SERVER is setup on C and what it need s DRIVE F for if anything other than a backlup. Can the F DRIVE be raided to it. Will taking of that drive mess up the SQL SERVER INSTALLED ON C
Thanks
SQLchic
April 7, 2009 at 1:25 pm
exec sp_msforeachdb 'select filename from ?..sysfiles'
will tell you where your databases are living
April 7, 2009 at 1:55 pm
I do not understand your answer. Please someone give more advice.
Thank you
SQLCHIC
April 8, 2009 at 12:04 pm
running the above command will help you determine whether any database(s) have
been created on your F: drive
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply