Restoring Databases to New Servers

I only have one Server running SQL. Daily I am performing full SQL backups
of the databases and moving them to tape offsite. If my the Server is
destroyed I will obtain a new machine. load SQL Sever and intend to restore
the backups off tape. I am told there is no clean way to do this because of
the GUID problems. Does anyone know of a clean way to do this or can direct
me to instructions as to how to do it?
Thanks.
Hi,
No issues at all. All you have to do is:-
1. Install SQL Server with same service pack as old
2. Restore Master database
3. Restore MSDB Database
4. Now Restore the user database one by one. If you want to apply
transaction log backups then use NORECOVERY option along with Restore
Database/
Restore Log command
Since you are restoring the MASTER database as well.. automatically Logins
and users will be syncronized.
Thanks
Hari
SQL Server MVP
"KED Florida" <KED Florida@.discussions.microsoft.com> wrote in message
news:0CCDB4D9-144C-4FB4-A345-141286B73983@.microsoft.com...
>I only have one Server running SQL. Daily I am performing full SQL backups
> of the databases and moving them to tape offsite. If my the Server is
> destroyed I will obtain a new machine. load SQL Sever and intend to
> restore
> the backups off tape. I am told there is no clean way to do this because
> of
> the GUID problems. Does anyone know of a clean way to do this or can
> direct
> me to instructions as to how to do it?
> Thanks.