June 15, 2010 at 4:15 am
i have a db, in which i create a FileGroup on a diffrend Physical disk, and put tables on.
if the disk with the FG dosen't work, how can i bring back the DB to work (i mean the orignal DB withought the FG)?
June 17, 2010 at 11:42 pm
I am assuming that you are speaking about SQL Server 2008. Can you tell me if it is the primary filegroup or the secondary filegroup that you are talking about.
Thanks.
June 18, 2010 at 12:25 am
i am talking about the FG which is on another hard-disk.
an i wantto know what can i do if that Hard-disk crash's
how can i still work with the Primary one?
June 18, 2010 at 2:08 am
This was removed by the editor as SPAM
June 18, 2010 at 3:45 am
peleg (6/18/2010)
i am talking about the FG which is on another hard-disk.an i wantto know what can i do if that Hard-disk crash's
how can i still work with the Primary one?
You can still "work" with the Primary file group by taking the files on the crashed disk offline.
However, you cannot make the file online without backup.
I would like to add two more points here:
1) You should have RAID. If a disk crashes, replace it with new one.
2) If you take data file offline, the objects on that file will become inaccessible. So your application may not "work".
Hope this answers your question.
June 18, 2010 at 4:15 am
SSC-Addicted thanks
1 more question
how do i take the FG offline as you mentioned?
June 18, 2010 at 4:27 am
This was removed by the editor as SPAM
June 18, 2010 at 4:13 pm
10X
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply