January 29, 2008 at 5:22 am
Windows Server 2003R2 w/ Sp2
SQL 2005 w/ Sp1
VERY limited knowledge of SQL.
I have figured out how to manually run a backup job. In the event I need to rebuild the server from scratch do i simply run the restore command or do i create the DB first and then run the restore to populate the DB?
Thanks in advance.
Kerry
January 29, 2008 at 9:03 am
will you need to rebuild/restore the system databases too?
To restore a user database you don't need to create a database first , you can restore straight from the backup file. Serach BOL for restoring user databases it will give you the syntax and GUI procedures for restoring a user db.
Gethyn Elliswww.gethynellis.com
January 30, 2008 at 6:31 am
Ellis RemoteDBA (1/29/2008)
will you need to rebuild/restore the system databases too?To restore a user database you don't need to create a database first , you can restore straight from the backup file. Serach BOL for restoring user databases it will give you the syntax and GUI procedures for restoring a user db.
[font="Verdana"]I will elaborate.
Windows Server 2003R2 w/ Sp2
MS SQL 2005 w/ Sp1
Automated Backup (backing up ALL databases)
Lets assume the hard drive failed in the system. I would need to rebuild the server from scratch. I would:
1. Install Windows Server 2003R2
2. Install MS SQL 2005 w/ Sp1
Would my immediate next step be to 'restore' the BAK file?
In order to make my db work properly do I need to restore the system db's as well?
Thanks,
Kerry[/font]
January 30, 2008 at 8:05 am
Hi Kerry,
Re-installing windows then reinstalling SQL Sever and then restoring the user DB from the BAk file, you will have a database that no users can access, no logins will exists. no maintenance or scheduled jobs will exist etc.
You could script the logins and recreate them on the re-installed server and then manually recreate the jobs and everything else stored in the system database or you can rebuild the master and restore the other (MSDB and Model) system databases from backup. The procudeures for rebuilding themaster are different from restoring regular user databases. Lookup the process in BOl or search thi site for more detailed information.
If you are new to SQL Server this is a good place to start.
Hope this helps
Gethyn Elliswww.gethynellis.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply