SQL 2000/Backup Exec Restore Problems 
Author Message
 SQL 2000/Backup Exec Restore Problems

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.



Sun, 18 Jul 2004 08:02:59 GMT
 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.



Wed, 21 Jul 2004 00:33:21 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Backup/Restore SQL 7 database problem (SQL 2000 installed on same server)

2. Backup Restore SQL 2000 - SQL 2000

3. problems with restoring msde 1.0 backups on sql 2000

4. Problems backup up SQL Server 7.0 with Backup Exec

5. Connection Issues With SQL Server 2000 And Backup Exec

6. Backup Exec 8.5 and SQL 2000

7. Cannot restore SQL databases from backup exec 7.3

8. SQL Restores - Veritas Backup Exec - Error

9. Restoring SQL Database from Backup Exec w/agent installed

10. How to restore SQL server 6.5 backup to SQL server 2000

11. Restoring SQL 7.0 backup to SQL 2000

12. SQL 7 backup file restored in SQL 2000?????


 
Powered by phpBB® Forum Software