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?