ARCSERVE 9 and SQL Restore Problem

[tonymce]

Hi all newbee to this site. wondered if anyone can help
Here is my situation
Had a server crash. restored the server from backup and it crashed.
decided to do a manual re-build then restore the database all went ok but i did not restore the model,master,msdb

The server is all ok now no problems.
My issue now is that it has just come to light that their was a DTS package on that server that was integral to the running of that server and it is missing.
I found out that the DTS packages are in the model,msdb well one of them.
So i built a new server and installed the same version of SQL and everything and then put the SQL agent on it.
I restored all of the databases fine but i cannot gt the 3 system databases to restore.
I have tried Single usermode for the master,model,msdb and then normal mode it just will not restore.
My question is this:

Can i restore these file as files only mdf then attach them if so HOW i have tried and tried CA support was useless it just cannot get it to work it seems that the sql agent does not store the mdf file at all it can only be extracted by the agent. i attempted to use the file groups only part but still nothing
PLESE HELP this is urgent..
Thank you all in advance

 

[mjhunter]

Had a look at this for you but I don't think I can help, you seem to have done everything I would have tried.

 

[vschumpy]

SQL version, ARCserve build? Error message reported? Sorry but we are not mind readers.

Flat file backups of SQL mdf and ldf databases are skipped automatically if you have the SQL DBAgent installed so that's a no-go.

Did you try JUST restoring the master DB on it's own in single user mode first (not in the same job as model or msdb) ?

 

[Cyklops]

What error messages on the restore jobs (brightstor.log - backup server and dbasql.log - sql server) ??

 

[tonymce]

Sorry SQL 2000 SP4
Arcerve 9.01
I tried the single usermode for the master but nothing
The error is not very imformative
error:

[09/05/2005-13:54:40 ,1,33,0,0,-1,2,18,0,0] Start Restore Operation. (QUEUE=1, JOB=1)
[09/05/2005-13:54:40 ,1,33,0,0,-1,2,18,0,0] Connected with SQL Server database agent at \\GLEDHILL-FTP.
[09/05/2005-13:59:39 ,1,33,9,0,-1,2,18,0,0] Use media APP_WEEK4, ID F5C9, sequence #1
[09/05/2005-13:59:39 ,1,33,9,0,-1,2,18,0,0] Source Session 9 on Media APP_WEEK4
[09/05/2005-13:59:39 ,1,33,9,0,-1,2,18,0,0] Target Directory: \\GLEDHILL-FTP\dbasql@MSSQLSERVER
[09/05/2005-13:59:56 ,1,33,0,0,-1,2,18,0,0] Connected with SQL Server database agent at \\GLEDHILL-FTP.
[09/05/2005-14:05:29 ,1,33,12,0,-1,2,18,0,0] Use media APP_WEEK4, ID F5C9, sequence #1
[09/05/2005-14:05:29 ,1,33,12,0,-1,2,18,0,0] Source Session 12 on Media APP_WEEK4
[09/05/2005-14:05:29 ,1,33,12,0,-1,2,18,0,0] Target Directory: \\GLEDHILL-FTP\dbasql@MSSQLSERVER
[09/05/2005-14:07:30 ,1,33,12,0,-1,2,1,0,0] E8603 Failed to write to database. (DBNAME=msdb, EC=GLEDHILL-FTP:[SQL Server] szSqlState = 37000,fNativeError = 3032, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]One or more of the options (recovery) are not supported for this statement. Review the documentation for supported options.)
[09/05/2005-14:07:30 ,1,33,12,0,-1,2,1,0,0] E8617 Failed to end restore. (DBNAME=msdb, EC=GLEDHILL-FTP:Backup Agent Error - (73) "SQL Server error. Please check the log file DBASQL.LOG". documentation for supported options.)
[09/05/2005-14:09:21 ,1,33,12,0,-1,2,18,0,0] ** Summary for Job **



SAME ERROR IN SINGLE USER MODE OR NOT

regarding the flat ffile you can restore the file groups opnly this is what i attempted but it still came up with the same errors

 

[tonymce]

i will get more information soon i am going to clear out the loggs and try different combo`s of the restore then post the results kk

 

[vschumpy]

Are you patched up at the host server and remote agent end? Check here :

http://supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC377202

It would also be helpful if you reviewed the dbasql.log that the activity log references, it sounds like you have checked an option in the database agent settings that isn't valid for restoring that database.

 

[tonymce]

i will try to get all of the loggs in today if not i am holiday so i will get someone elst to do it but i will try cheers for the info atm it is very much appreciated

 

[tonymce]

i have not pached the remote end my bad LOL
the server is fully patched but the remote is standared
I will try that now cheers all ill report back asap
ty

 

[tonymce]

I am on buile 2100 on the server and nothing in the client i will do it now kk

 

[tonymce]

ARRRRRRRRRRRRG
still not working i have the same version 2100 on both but i am getting
cannot restore msdb databse is in use.
so i tried single user mode
still not working it then says you can only restore master in single user mode.
i am now trying it will all engines stopped to see if the sql invokes the sql engine itself otherwise i nolonger have a clue.
the user credentials are all ok
the sql servers aer the same version and the arcserve is the same version but it will not restore the msdb i can restore all other databases except for the system databases this is getting annoying. i thought arcserve was a total solution instead they seem to not work very well. i would prefer to get the files themselved off the tape and re-attach them to the databse but i cannot find out how to do that. i have playeed about with the file group stuff in the sql agent to try to restore the file groups only to a different location but it does nothing
HELP !!!

 

[vschumpy]

It still sounds as if you are having problems with SQL - not ARCserve.

File groups is not a flat-file restore option it is just another way to restore SQL data files.

What is the EXACT message you get in the dbasql.log? You mention trying to restore msdb, then mention an error about master?

If you enabled an SQL Profiler trace in SQL this may also give you a clue as to what is going on at the SQL end (although most of this should be in the dbasql.log).

One other thought - after stopping SQL and re-starting the service in single user mode - did you also stop and restart the DBAgent service then try your restore, on the chance that the dbagent process got orphaned from the SQL instance and brought up a false message?

 

[DebiJo]

When you put SQL in single user mode, what user did you use? And are you using the same one for your restore?

I am curios though, when you posted your log, the database was msdb, not master. Which one are you trying to restore?

Restoring the master database works, it really does, I've done it.

Debi

 

[tonymce]

i used the domain admin account it is ok to restore all databases except the mdb and the master all i am after is the mdb (that is where the dts package is stored i think)