restore all database

Hi, again me, just a simple question, how can I restore all my
databases from a full backup.
Not one by one, instead I=B4d like to do this un just one automatized
process, where the user just start it and forget it.
Thanks in advanceHow many databases?
On the same server?
Where are the backups stored?
Do they need to be restored in any particular order?
One by One or More than one at a time?
<gnp1977@.gmail.com> wrote in message
news:1173455294.155935.304470@.s48g2000cws.googlegroups.com...
Hi, again me, just a simple question, how can I restore all my
databases from a full backup.
Not one by one, instead Id like to do this un just one automatized
process, where the user just start it and forget it.
Thanks in advance|||Hi Immy, thanks for your answer,
I need take de DB's from one server to a standby server for Continuity
of Bussines.
The backups are stored on hard disks
No order needed
Can I restore more than one DB at a time?
My DB's have 35Mb the tiny one and 15Gb the bigger one
Thanks in advance|||Here is a Stored procedure that may work
I never used it but it looks pretty straight forward.
go
-- Delete procedure if exists
if exists (
select *
from dbo.sysobjects
where id = object_id('dbo.procRestoreDatabase')
and OBJECTPROPERTY(id, 'IsProcedure') = 1)
drop procedure dbo.procRestoreDatabase
go
-- Create stored procedure
create procedure dbo.procRestoreDatabase (
@.dbname varchar(128),
@.path varchar(128),
@.file varchar(128),
@.LogicalName_Data varchar(128),
@.LogicalName_Log varchar(128),
@.PhysicalName_Date varchar(128),
@.PhysicalName_Log varchar(128))
as
/ ****************************************
**********************************
*
* procRestoreDatabase
*
* Version : 1.00
* Date : 2003 may 23
*
****************************************
**********************************/
-- Execute 'restore database'
exec ('
restore database [' + @.dbname + ']
from disk = ''' + @.path + '' + @.file + '''
with move ''' + @.LogicalName_Data + ''' to ''' + @.PhysicalName_Date + ''',
move ''' + @.LogicalName_Log + ''' to ''' + @.PhysicalName_Log + ''',
recovery,
replace,
stats = 10
')
go|||Excuse me, I=B4m note DBA, so I don=B4t know how to use the stored
procedure... even I understand what is it but I don=B4t know how to use
it.
Somebody can explain me?
Thanks|||I think you can better hire a database administrator for this or consult one
.
Just my 2 cents|||<gnp1977@.gmail.com> wrote in message
news:1173465269.837460.124020@.p10g2000cwp.googlegroups.com...
Excuse me, Im note DBA, so I dont know how to use the stored
procedure... even I understand what is it but I dont know how to use
it.
Somebody can explain me?
Thanks
I'm with Hate_Orphaned_Users on this one.
Hire a consultant or get a DBA in there. No offense, but sounds like
they're asking you to put into place a DR plan (you mention continuity of
business) that you're probably not going to be able to fully support in the
event of an emergency.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com