I have sql 2000 on a server and the same on another both with the same service pack.
Also i have arcserve 9.01 (same version on both) with SQL agent installed i am having problems restoring to the second PC a restore from the 1st pc i cannot restore the MSDB to the 1st PC because it is operational so i decided to restore it to another server. I am after a DTS package i was told it was stored in the MSDB but i cannot get it to restore. the tape drive is in PC1 and it is using the agent to restore to PC2 i can do databases fine but i cannot do the MSDB i have attempted to put it into single user mode and nothing i am using the domain god account using my fqdn to login. so security is not an issue i am at a lost can anyone help.
I would love it if i could get the MSDB file only off the tape then mount it on PC2 if that is possible if so i cannot seem to find out how to make it work.
Thank you in advance
Also i have arcserve 9.01 (same version on both) with SQL agent installed i am having problems restoring to the second PC a restore from the 1st pc i cannot restore the MSDB to the 1st PC because it is operational so i decided to restore it to another server. I am after a DTS package i was told it was stored in the MSDB but i cannot get it to restore. the tape drive is in PC1 and it is using the agent to restore to PC2 i can do databases fine but i cannot do the MSDB i have attempted to put it into single user mode and nothing i am using the domain god account using my fqdn to login. so security is not an issue i am at a lost can anyone help.
I would love it if i could get the MSDB file only off the tape then mount it on PC2 if that is possible if so i cannot seem to find out how to make it work.
Thank you in advance