change the server**

Hi
I've a server which includes sql server2000
with somje databases,and now I want to transfer
all database into a new server(which just has a SQL server 2000 and SP3
with no databases) ,is it neccessary
to restore the master or model or any other default
databases in new server?
I want to do following steps:
Is there any more activities needed to transfer all info.?
1 - backup all DBs(except default dbs like master,..).
2 - restore DBs in new server.
3 - define logins and link them to users.
4 - define jobs or some maintanace plan.
Is there any better way to do this?
any help would be greatly thankful.
Hi,
Your steps are 75% good, but if you restore the Master, MSD database then
you donot want create the logins, Jobs, Maintenance plans, operators ,
alerts etc..
Master holds the Logins, configuration parameters
MSDB Holds all the jobs, Maintenance plans, operators, alerts etc..
Go thru the below links to transfer all the databases including system
databases/
http://www.support.microsoft.com/?id=224071
http://support.microsoft.com/default...b;en-us;314546
Is it neccessary to restore the master or model or any other default
databases in new server?
Yes, this will reduce quite a lot of manual stuffs explained above.
Thanks
Hari
MCDBA
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsawkt1l8hqligo@.msnews.microsoft.com...
> Hi
> I've a server which includes sql server2000
> with somje databases,and now I want to transfer
> all database into a new server(which just has a SQL server 2000 and SP3
> with no databases) ,is it neccessary
> to restore the master or model or any other default
> databases in new server?
> I want to do following steps:
> Is there any more activities needed to transfer all info.?
> 1 - backup all DBs(except default dbs like master,..).
> 2 - restore DBs in new server.
> 3 - define logins and link them to users.
> 4 - define jobs or some maintanace plan.
> Is there any better way to do this?
> any help would be greatly thankful.
|||thanks,
and the last question :
Is the order of restoring dbs (first system db,then the other)or (first
the other ,then system db) important?
On Sat, 10 Jul 2004 09:18:43 +0530, Hari Prasad
<hari_prasad_k@.hotmail.com> wrote:

> Hi,
> Your steps are 75% good, but if you restore the Master, MSD database then
> you donot want create the logins, Jobs, Maintenance plans, operators ,
> alerts etc..
> Master holds the Logins, configuration parameters
> MSDB Holds all the jobs, Maintenance plans, operators, alerts etc..
> Go thru the below links to transfer all the databases including system
> databases/
> http://www.support.microsoft.com/?id=224071
> http://support.microsoft.com/default...b;en-us;314546
>
> Is it neccessary to restore the master or model or any other default
> databases in new server?
> Yes, this will reduce quite a lot of manual stuffs explained above.
> Thanks
> Hari
> MCDBA
>
> "RM" <m_r1824@.yahoo.co.uk> wrote in message
> news:opsawkt1l8hqligo@.msnews.microsoft.com...
>
|||Hi,
Go with system databases first and then restore the user databases. But
ensure that you restart the MSSQL server service only after
restoring all databases. Otherwise database will be marked suspect.
Thanks
Hari
MCDBA
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsawmhtkahqligo@.msnews.microsoft.com...[vbcol=seagreen]
> thanks,
> and the last question :
> Is the order of restoring dbs (first system db,then the other)or (first
> the other ,then system db) important?
>
> On Sat, 10 Jul 2004 09:18:43 +0530, Hari Prasad
> <hari_prasad_k@.hotmail.com> wrote:
then
>
|||Hi
as I read the article ,I 've got some question:
it said restore backup of your dbs in full case and with norecovery
and then restore the transaction log backup with recovery.
is it neccessary to restore transaction log file after we reostored
the database complete?
and why for the first we should do it with norecovery and for the second
we should do it with recovery?
and it said to change the location of dat and log files you
should use with move option in restioring database,but there
was no 'with move option' in restoring 2 tab pages,and
to change the location after we select the device ,I think
it is enough to change the path manually in option tab( second tab).
isn't it?
thanks
On Sat, 10 Jul 2004 09:18:43 +0530, Hari Prasad
<hari_prasad_k@.hotmail.com> wrote:

> Hi,
> Your steps are 75% good, but if you restore the Master, MSD database then
> you donot want create the logins, Jobs, Maintenance plans, operators ,
> alerts etc..
> Master holds the Logins, configuration parameters
> MSDB Holds all the jobs, Maintenance plans, operators, alerts etc..
> Go thru the below links to transfer all the databases including system
> databases/
> http://www.support.microsoft.com/?id=224071
> http://support.microsoft.com/default...b;en-us;314546
>
> Is it neccessary to restore the master or model or any other default
> databases in new server?
> Yes, this will reduce quite a lot of manual stuffs explained above.
> Thanks
> Hari
> MCDBA
>
> "RM" <m_r1824@.yahoo.co.uk> wrote in message
> news:opsawkt1l8hqligo@.msnews.microsoft.com...
>
|||Hi,
is it neccessary to restore transaction log file after we reostored
the database complete?
No need.
This will be required when there is a recovery. Trasnaction log will be
restored if there are tranasctions after full database backup.
why for the first we should do it with norecovery and for the second we
should do it with recovery?
Say if you have 1 full backup and need to restore transaction log backup. So
restore the Full backup with NORECOVERY. This
Instructs the restore operation to not roll back any uncommitted
transactions. users cant access the database in this mode.
While restoring the final trasnaction log use the Recovery option. This
Instructs the restore operation to roll back any uncommitted transactions.
After the recovery process, the database is ready for use.
Move option for changing location of MDF and LDF.
Look into the RESTORE DATABASE command in Books online.
In Enter prise manager also you can change the location while restoring.
Chaging the path after restore
see the commands sp_detach_db and sp_attach_db in books online.
Thanks
Hari
MCDBA
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsawnnkjqhqligo@.msnews.microsoft.com...[vbcol=seagreen]
> Hi
> as I read the article ,I 've got some question:
> it said restore backup of your dbs in full case and with norecovery
> and then restore the transaction log backup with recovery.
> is it neccessary to restore transaction log file after we reostored
> the database complete?
> and why for the first we should do it with norecovery and for the second
> we should do it with recovery?
> and it said to change the location of dat and log files you
> should use with move option in restioring database,but there
> was no 'with move option' in restoring 2 tab pages,and
> to change the location after we select the device ,I think
> it is enough to change the path manually in option tab( second tab).
> isn't it?
> thanks
>
> On Sat, 10 Jul 2004 09:18:43 +0530, Hari Prasad
> <hari_prasad_k@.hotmail.com> wrote:
then
>