Script log-shipping configuration and steps for disaster recovery

I am making the disaster recovery plan for the sql 2005 databases at
my company (Standard Edition). I have around 40 databses, so after
configuring log shipping using the wizard I wonder if there is a way
of script this so I just run the script for the rest of the databases
instead of going through the wizard 40 times.

I have tried to copy and paste the script the wizard generated and
change the database server and name, share folder ... BUT THIS WAY
DOESNT WORK. Is there a way ? website with directions ?

2) Is there a way to change roles with a script in sql 2005 the same
way sql 2000 had those two comands (sp_change_primary_role and
sp_change_secondary_role) ??? I just dont want to go through any
wizard if a disaster occurs.

Thanks for anyone that can bring some light to this.

.

Relevant Pages

  • Re: Recovery Model Question.
    ... Take the result of the script, paste in into a query window and execute it. ... I run this sql script through Query Analyzer: ... to any databases!I check the recovery model and remains unfortunately full in all databases.. ...
    (microsoft.public.sqlserver.tools)
  • Re: creating unique index and clustered index in sql server management studio
    ... the script database that is in the wizard is capable of generating the ... SQL 2000 GUI created the indexes by creating a constraint while the new SQL ... >> the indexes or index constraints are recreated. ... > Scripts wizard found by right clicking on the DB under Tasks. ...
    (microsoft.public.sqlserver.tools)
  • Re: MS SQL 2005 Express Edition - Replication Question
    ... What I do is to turn on "generate script" (there is a toolbar button ... I'm new to MS SQL, ... laptop, create and/or test the databases, when ready transfer the ... Something like replication? ...
    (comp.databases.ms-access)
  • Re: MS SQL 2005 Express Edition - Replication Question
    ... What I do is to turn on "generate script" (there is a toolbar button ... I'm new to MS SQL, ... laptop, create and/or test the databases, when ready transfer the ... Something like replication? ...
    (comp.databases.ms-access)
  • Re: Anyway to automatical generate script to populated DB from Access
    ... If you are using SQL 2000, look at the Import Wizard. ... we are manually running the Access upsizing Wizard, then running a script ... add the constraints/relationships back in. ...
    (microsoft.public.sqlserver.tools)