Hello,
Had a system failure and the disk volume, where all
databases were resided on, was gone.
SQL application is on a different disk volume, and there
is BAK copy for master, msdb and a user database.
Who can share his/her experience or lead me to tech info
links to rebuild the database?
Thanks in advance.
EricYou might want to pay the $250.00 or so for tech support to walk you thru
this:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
But here are some links that may help along with the BooksOnLine help file:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
Andrew J. Kelly
SQL Server MVP
"Eric Chen" <eric.chen@.broadvision.com> wrote in message
news:2b4301c33f56$c01fe940$a401280a@.phx.gbl...
> Hello,
> Had a system failure and the disk volume, where all
> databases were resided on, was gone.
> SQL application is on a different disk volume, and there
> is BAK copy for master, msdb and a user database.
> Who can share his/her experience or lead me to tech info
> links to rebuild the database?
> Thanks in advance.
> Eric
>
No comments:
Post a Comment