restore question

I have SQL2000 server with 300 databases. I have a maintenance plan that
performs a full backup of all databases every night.
I have performed test restores of some of those databases but now I'm
wondering in case that something catastrophic happens and I have to restore
entire SQL server, how can I do that?
Would I have to restore every database separately or is there a way to
restore all of them in one step (some transact SQL script ...)?
Tom
Hi,
Best option is to restore the system databases first and then restore the
User databases one by one. You could write the RESTORE DATABASE
Script and execute it from Query Analyzer in a single execution.
See the below URLS for the step by step approach with different
methodologies:-
http://support.microsoft.com/default...b;en-us;304692
http://support.microsoft.com/default...b;en-us;224071
http://support.microsoft.com/default...b;en-us;314546
Thanks
Hari
SQL Server MVP
"Tom" <mcseman2002@.hotmail.com> wrote in message
news:%23XIEZ1VjFHA.2904@.tk2msftngp13.phx.gbl...
>I have SQL2000 server with 300 databases. I have a maintenance plan that
>performs a full backup of all databases every night.
> I have performed test restores of some of those databases but now I'm
> wondering in case that something catastrophic happens and I have to
> restore entire SQL server, how can I do that?
> Would I have to restore every database separately or is there a way to
> restore all of them in one step (some transact SQL script ...)?
> Tom
>
|||Hi Tom,
This gives you an opportunity to move some of the databases to different
servers, to mitigate the risk of running all the databases on the same server.
Also make sure that you are running the server on disk array's, to avoid any
disk failures.
For avoid dependency on OS, you can look at fail-over clusterting also.
- - - - - - - - -
Thanks
Yogish
"Tom" wrote:

> I have SQL2000 server with 300 databases. I have a maintenance plan that
> performs a full backup of all databases every night.
> I have performed test restores of some of those databases but now I'm
> wondering in case that something catastrophic happens and I have to restore
> entire SQL server, how can I do that?
> Would I have to restore every database separately or is there a way to
> restore all of them in one step (some transact SQL script ...)?
> Tom
>
>

restore question

I have SQL2000 server with 300 databases. I have a maintenance plan that
performs a full backup of all databases every night.
I have performed test restores of some of those databases but now I'm
wondering in case that something catastrophic happens and I have to restore
entire SQL server, how can I do that?
Would I have to restore every database separately or is there a way to
restore all of them in one step (some transact SQL script ...)?
TomHi,
Best option is to restore the system databases first and then restore the
User databases one by one. You could write the RESTORE DATABASE
Script and execute it from Query Analyzer in a single execution.
See the below URLS for the step by step approach with different
methodologies:-
http://support.microsoft.com/default.aspx?scid=kb;en-us;304692
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
Thanks
Hari
SQL Server MVP
"Tom" <mcseman2002@.hotmail.com> wrote in message
news:%23XIEZ1VjFHA.2904@.tk2msftngp13.phx.gbl...
>I have SQL2000 server with 300 databases. I have a maintenance plan that
>performs a full backup of all databases every night.
> I have performed test restores of some of those databases but now I'm
> wondering in case that something catastrophic happens and I have to
> restore entire SQL server, how can I do that?
> Would I have to restore every database separately or is there a way to
> restore all of them in one step (some transact SQL script ...)?
> Tom
>|||Hi Tom,
This gives you an opportunity to move some of the databases to different
servers, to mitigate the risk of running all the databases on the same server.
Also make sure that you are running the server on disk array's, to avoid any
disk failures.
For avoid dependency on OS, you can look at fail-over clusterting also.
--
- - - - - - - - -
Thanks
Yogish
"Tom" wrote:
> I have SQL2000 server with 300 databases. I have a maintenance plan that
> performs a full backup of all databases every night.
> I have performed test restores of some of those databases but now I'm
> wondering in case that something catastrophic happens and I have to restore
> entire SQL server, how can I do that?
> Would I have to restore every database separately or is there a way to
> restore all of them in one step (some transact SQL script ...)?
> Tom
>
>

restore question

I have SQL2000 server with 300 databases. I have a maintenance plan that
performs a full backup of all databases every night.
I have performed test restores of some of those databases but now I'm
wondering in case that something catastrophic happens and I have to restore
entire SQL server, how can I do that?
Would I have to restore every database separately or is there a way to
restore all of them in one step (some transact SQL script ...)?
TomHi,
Best option is to restore the system databases first and then restore the
User databases one by one. You could write the RESTORE DATABASE
Script and execute it from Query Analyzer in a single execution.
See the below URLS for the step by step approach with different
methodologies:-
http://support.microsoft.com/defaul...kb;en-us;304692
http://support.microsoft.com/defaul...kb;en-us;224071
http://support.microsoft.com/defaul...kb;en-us;314546
Thanks
Hari
SQL Server MVP
"Tom" <mcseman2002@.hotmail.com> wrote in message
news:%23XIEZ1VjFHA.2904@.tk2msftngp13.phx.gbl...
>I have SQL2000 server with 300 databases. I have a maintenance plan that
>performs a full backup of all databases every night.
> I have performed test restores of some of those databases but now I'm
> wondering in case that something catastrophic happens and I have to
> restore entire SQL server, how can I do that?
> Would I have to restore every database separately or is there a way to
> restore all of them in one step (some transact SQL script ...)?
> Tom
>|||Hi Tom,
This gives you an opportunity to move some of the databases to different
servers, to mitigate the risk of running all the databases on the same serve
r.
Also make sure that you are running the server on disk array's, to avoid any
disk failures.
For avoid dependency on OS, you can look at fail-over clusterting also.
--
- - - - - - - - -
Thanks
Yogish
"Tom" wrote:

> I have SQL2000 server with 300 databases. I have a maintenance plan that
> performs a full backup of all databases every night.
> I have performed test restores of some of those databases but now I'm
> wondering in case that something catastrophic happens and I have to restor
e
> entire SQL server, how can I do that?
> Would I have to restore every database separately or is there a way to
> restore all of them in one step (some transact SQL script ...)?
> Tom
>
>