SQL Server >> Restore SQL databes to diffrent server using Scripts
I hope someone here can point me in the right direction.
We currently have a "Live" server and a "Backup" server both using SQL
server 2000.
We are trying automating the database restore between these servers if
possible.
It is currently being done by hand.
We have 40 Databases to recover. They are not that big, just time
consuming to restore the data and fix the assigned users which are not
recreated during the restore.
We use the "sp_change_users_login auto_fix, <username>" to recreate the
link between the user and its database.
Is there a way to script this? I'm not very fluent with SQL and queries
so I'm not sure if scripting this or a stored procedure would be easy
to setup.
SQL Server >> Restore SQL databes to diffrent server using Scripts
You could consider creating a DTS Package to do this for you. Here are some
articles that will help :-
>I hope someone here can point me in the right direction.
>
> We currently have a "Live" server and a "Backup" server both using SQL
> server 2000.
> We are trying automating the database restore between these servers if
> possible.
> It is currently being done by hand.
>
> We have 40 Databases to recover. They are not that big, just time
> consuming to restore the data and fix the assigned users which are not
> recreated during the restore.
>
> We use the "sp_change_users_login auto_fix, <username>" to recreate the
> link between the user and its database.
>
> Is there a way to script this? I'm not very fluent with SQL and queries
> so I'm not sure if scripting this or a stored procedure would be easy
> to setup.
>
>
> Any help will be gratefully received!
>
> Bill C
>