Database recovery

Hi All,
Plaese excuse me if this sounds like a stupid question, my SQL sever crashed
and all my databases are gone. Which steps do I follow to restore my
database. In the backup folder of the Sql there is folders of database names
containg the table names with the extension "bak". Please help
For Each db,
Restore database <dbname> from disk = <completefilename>
You need to determine if you have log backups or only full database backups.
If you have log backups, then each db restore you should add ' with
norecovery', and use the restore log command to restore the logs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nkagi" <Nkagi@.discussions.microsoft.com> wrote in message
news:A0128E1C-76A2-4FFE-B977-E36759C436BF@.microsoft.com...
> Hi All,
> Plaese excuse me if this sounds like a stupid question, my SQL sever
crashed
> and all my databases are gone. Which steps do I follow to restore my
> database. In the backup folder of the Sql there is folders of database
names
> containg the table names with the extension "bak". Please help
|||To add to what Wayne has to say,
You should read the entire section on Backup and Recovery in the Books
Online. That way, you know that you covered all of your bases during the
restore process.
Rick Sawtell
MCT, MCSD, MCDBA
|||You will have to restore the master database first, then the model and msdb.
All of the remaining user databases can then be restored.
Make sure that you have brought the installation back to the same service
pack and hotfix levels before restore the master database.
Sincerely,
Anthony Thomas

"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:ud9IkmN7EHA.2316@.TK2MSFTNGP15.phx.gbl...
For Each db,
Restore database <dbname> from disk = <completefilename>
You need to determine if you have log backups or only full database backups.
If you have log backups, then each db restore you should add ' with
norecovery', and use the restore log command to restore the logs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nkagi" <Nkagi@.discussions.microsoft.com> wrote in message
news:A0128E1C-76A2-4FFE-B977-E36759C436BF@.microsoft.com...
> Hi All,
> Plaese excuse me if this sounds like a stupid question, my SQL sever
crashed
> and all my databases are gone. Which steps do I follow to restore my
> database. In the backup folder of the Sql there is folders of database
names
> containg the table names with the extension "bak". Please help
|||"Nkagi" <Nkagi@.discussions.microsoft.com> wrote in message
news:A0128E1C-76A2-4FFE-B977-E36759C436BF@.microsoft.com...
> Hi All,
> Plaese excuse me if this sounds like a stupid question, my SQL sever
crashed
> and all my databases are gone. Which steps do I follow to restore my
> database. In the backup folder of the Sql there is folders of database
names
> containg the table names with the extension "bak". Please help
You may also want to look for any .MDF and .LDF files.
It MAY be possible to reinstall SQL Server and them simply reattach these
sp_attach_db.
These will probably be more recent than your backups.