Odd Mirroring Issue

Question

Odd Mirroring Issue

RobehL

SSC Enthusiast

Points: 121
More actions
March 27, 2015 at 10:29 am

#299084

So after my Sans storage that contains the MSSQL db files crashed, i had to rebuild the entire array. Now, my secondary server mirroring also shows up as "Disconnected".
When i right click on a database, i do not have an option to click on restore. I took the DB offline and i can't bring it back online.
I wanted to re-attached the entire database, but i do not have the .mdf file. I can't copy the .mdf file from the principal server unless i de-attach the database first, but i don't want to do that since the database is being used.
Please advise 🙂
Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

peacesam (3/27/2015)
So after my Sans storage that contains the MSSQL db files crashed, i had to rebuild the entire array.

This is on the primary server?

Where are the backups from the primary?

peacesam (3/27/2015)
Now, my secondary server mirroring also shows up as "Disconnected".
When i right click on a database, i do not have an option to click on restore.

No you wont, you'll have to manually recover it using

RESTORE DATABASE [thesecondarydb] WITH RECOVERY

peacesam (3/27/2015)
I wanted to re-attached the entire database, but i do not have the .mdf file. I can't copy the .mdf file from the principal server unless i de-attach the database first, but i don't want to do that since the database is being used.
Please advise 🙂
Thank you.

Re attach from where?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

RobehL SSC Enthusiast Points: 121 More actions · Answer 2

Thanks for your help, please see my answers below.

Perry Whittle (3/27/2015)
peacesam (3/27/2015)
So after my Sans storage that contains the MSSQL db files crashed, i had to rebuild the entire array.
This is on the primary server? Response: This is on the Secondary server.
Where are the backups from the primary?Response:Backups are coming from primary.
peacesam (3/27/2015)
Now, my secondary server mirroring also shows up as "Disconnected".
When i right click on a database, i do not have an option to click on restore.
No you wont, you'll have to manually recover it using
RESTORE DATABASE [thesecondarydb] WITH RECOVERY
Response: This is the error i get from running the above query:
Msg 3148, Level 16, State 3, Line 1
This RESTORE statement is invalid in the current context. The 'Recover Data Only' option is only defined for secondary filegroups when the database is in an online state. When the database is in an offline state filegroups cannot be specified.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally
peacesam (3/27/2015)
I wanted to re-attached the entire database, but i do not have the .mdf file. I can't copy the .mdf file from the principal server unless i de-attach the database first, but i don't want to do that since the database is being used.
Please advise 🙂
Thank you.
Re attach from where?

Response: So i went to my primary database, did a full backup and copy over to secondary server. I wanted to use the backup and put it on the secondary SQL server so i can start all over on the mirroring.