SQL 2000/Backup Exec Restore Problems
This is not my favorite issue, since I've had some problems with recovering
master databases, but I'm quite certain that SQL Server doesn't start
because it is unable to create tempdb, which is a copy of the
model-database. Restore the datafile for model and place it on the right
spot in the filesystem and you will be able to start the machine. I don't
know about the msdb-database, but I think it needs to be there as well.
Regards/Marwin
Quote:
> All,
> I have a test network setup consisting of a replica of my NT4.0 PDC
> and a box I am testing disaster recovery of our SQL 2000 production
> server on.
> The test box has been installed with the same netbios name as the
> production server, Windows 2000SP1 and SQL 2000(with the correct
> settings for collation, etc.) and Backup Exec 8.6. The test box
> ofcourse has differing hardware than the production server(I seem to
> have misplaced my extra dual processor Netfinity 6000 somewhere).
> After the test box is preped as described above, I run a restore of
> the master database(only the master) using Recover Database, no DBCC
> and Replace existing Database Files with the database in single-user
> mode(/m). After the restore runs successfully and I attempt to
> restart the stopped SQLServer service in multi-user mode to procede
> with recovering the rest of my DBs, the service fails to start.
> Upon checking the event logs, I've found that the service is looking
> for the model database to be able to start. According to every
> document I've read from Veritas, I'm following the correct procedure,
> but apparently I'm not.
> Please take me to school on this.
> Later, gary.
