SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 RBS path lost and database is in recovery pending
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mahya
Starting Member

1 Posts

Posted - 01/10/2014 :  02:08:48  Show Profile  Reply with Quote
Hi friends
This is my first post in this forum and I hope so to share useful information here.

The problem is that I launched few day ago RBS service (Remote BLOG Storage) on SQL server 2012 and selected a path in an attached storage to server for storing files. But a problem has been occurred for storage and I have lost my route and all information into it. So my database situation has been change to recovery pending mode and even I cannot change the route which I have set already. Because my database is in recovery pending mode and in this mode, application does not allow me to execute Alter command.
I have searched in internet to find alternatives for changing my database mode from Recovery pending to Online. But all alternatives want me to dissolve the problem in storage route of files in RBS configuration.

What resolutions are there? Please help me…..
Sincerely

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1770 Posts

Posted - 01/13/2014 :  18:44:42  Show Profile  Reply with Quote
In Re: "But a problem has been occurred for storage"
What is the problem? It sounds to me that you want to find and correct this issue and then the database "should" come online. Also, are there any messages in the SQL Logs that may shed some light on what file or resource is causing the issue?

=================================================
A man is not old until regrets take the place of dreams. - John Barrymore

Edited by - Bustaz Kool on 01/13/2014 18:45:53
Go to Top of Page

NehwalSaina
Starting Member

India
2 Posts

Posted - 01/27/2014 :  06:43:06  Show Profile  Reply with Quote
You can use Kernel for SQL Recovery Software for the recovery of your SQL Server Database instantly. Go to http://www.sqlrepair.org to know more about SQL Server Recovery Process and download the demo software to recover your SQL Database successfully.
Go to Top of Page

Lincolnburrows
Starting Member

43 Posts

Posted - 07/26/2014 :  03:25:14  Show Profile  Reply with Quote
SQL database in recover pending may cause loss of SQL database and for this critical issue you must use external tool. Read more about how to prevent SQL database from recovery mode from here:- http://www.sqlrepairtool.org/repair-mdf.html
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000