Filegroup which is not online

Aaron Bertrand Aaron Bertrand k 25 25 gold badges silver badges bronze badges. If someone else is trying to restore the filegroup from backups, running this statement could also lead to a rough weekend. That's why I asked for the current state first. JonSeigel I thought it was a fair assumption that only one person is working on this database. If someone else is already trying to restore this file group, this operation should just fail immediately - no long weekend involved.

Ah yes, you're right, either it's up to the current point in time or not. I agree your answer is a possible resolution; still, I'm wary of taking an action without knowing more about the situation, like why is this filegroup not online in the first place?

Jon I took that as "no longer employed here. AaronBertrand, thanks for your answer. I tried the solution, but I got The file or filegroup "logSoundFile" is not in a valid state for the "Recover Data Only" option to be used.

Show 1 more comment. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? You could also skip 4. Skip to content filegroups sql server I'm trying to backup a database, which has been created by someone I don't have access to.

I get this error message: The backup of the file or filegroup "fileStream" is not permitted, because it is not online.

Best Answer. Related Question. Tagged: Backup fails , Backup restore , Offline file group , piecemeal restore. You can follow any responses to this entry through the RSS 2. You can leave a response , or trackback from your own site. For most recent information you have to pay a visit web and on internet I found this web page as a finest site for newest updates. I recently just like the helpful information anyone present on your articles.

All the best. Looking at this article reminds me of my previous roommate! He continually kept preaching about this. I most certainly will forward this post to him. Thanks for sharing! Everyone loves it when individuals get together and share opinions. Great website, keep it up! Great post. I was checking continuously this blog and I am impressed! I was looking for this certain info for a long time. Thank you and good luck. On Fb, DStv is trying to appease indignant subscribers who complain about just one film being out there.

Its not my first time to visit this web page, i am visiting this web site dailly and get pleasant facts from here all the time. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account.

You are commenting using your Facebook account. Notify me of new comments via email.