Db restore ques.

Is it possible to restore a database if you have not been
doing db backup but you were doing server backups.Or does
server backups include database backups. And how do you
restore the database. Please help.It depends on what you've been using to do the backups.
Ideally you backup SQL Server databases from within SQL Server, the
resulting backup file can then be put onto tape with your file backup
utility. Does your backup software have SQL Server Agents loaded or has it
been skipping the database files as they are in use..?
--
HTH
Ryan Waight, MCDBA, MCSE
"Naz" <milnaz@.hotmail.com> wrote in message
news:110f01c38cc7$0f82d980$a101280a@.phx.gbl...
> Is it possible to restore a database if you have not been
> doing db backup but you were doing server backups.Or does
> server backups include database backups. And how do you
> restore the database. Please help.|||Naz
If you have copies of your .mdf and .ldf files, you may be
able to use sp_attach_db to attach them. Most server
backups do not pick up these files as they show as being
in use, so you might not have them.
Regards
John|||got it. They were some database backups.
>--Original Message--
>Naz
>If you have copies of your .mdf and .ldf files, you may
be
>able to use sp_attach_db to attach them. Most server
>backups do not pick up these files as they show as being
>in use, so you might not have them.
>Regards
>John
>.
>