Re: Tivoli SQL Server 2000 Restore Question*
Del, Thanks again for your response. Tim Del Hoobler wrote: Tim, Yes... you are on the right track. Take a look in the appendices of the Data Protection for SQL User's Guide. It shows how to restore master and msdb. Note: When you restore master, you will see an error at the end of the restore procedure. That is normal. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/28/2007 02:22:18 PM: Default *SQL Server 2000 Restore Question* I am restoring a SQL Server 2000 from scratch. The server has been built and SQL has been installed and service packed to the appropriate level. I am ready to restore the databases now to the fresh installation of SQL Server. Is this the correct procedure when only the default databases exist? Start SQL in single user mode. Restore Master database. Start SQL in multi user mode and restore msdb and model. Restore the database files? Thanks for any help or suggestions in advance! TSM 5.3 Windows 2000 advance server TDP 5.2.4 Tivoli Client 5.3.4
Re: Tivoli SQL Server 2000 Restore Question*
Tim, Yes... you are on the right track. Take a look in the appendices of the Data Protection for SQL User's Guide. It shows how to restore master and msdb. Note: When you restore master, you will see an error at the end of the restore procedure. That is normal. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/28/2007 02:22:18 PM: Default *SQL Server 2000 Restore Question* I am restoring a SQL Server 2000 from scratch. The server has been built and SQL has been installed and service packed to the appropriate level. I am ready to restore the databases now to the fresh installation of SQL Server. Is this the correct procedure when only the default databases exist? Start SQL in single user mode. Restore Master database. Start SQL in multi user mode and restore msdb and model. Restore the database files? Thanks for any help or suggestions in advance! TSM 5.3 Windows 2000 advance server TDP 5.2.4 Tivoli Client 5.3.4
Tivoli SQL Server 2000 Restore Question*
Default *SQL Server 2000 Restore Question* I am restoring a SQL Server 2000 from scratch. The server has been built and SQL has been installed and service packed to the appropriate level. I am ready to restore the databases now to the fresh installation of SQL Server. Is this the correct procedure when only the default databases exist? Start SQL in single user mode. Restore Master database. Start SQL in multi user mode and restore msdb and model. Restore the database files? Thanks for any help or suggestions in advance! TSM 5.3 Windows 2000 advance server TDP 5.2.4 Tivoli Client 5.3.4