Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kerrycorcoran
Starting Member
38 Posts |
 Posted - 2008-01-29 : 07:24:21
|
| Windows Server 2003R2 w/ Sp2SQL 2005 w/ Sp1VERY 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 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-29 : 07:41:03
|
The restore also creates the database.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-01-29 : 07:51:28
|
| So, if I simply install the OS, install SQL and run the restore the DB should be fully functional? No additional steps? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-02 : 00:35:55
|
| Still need create sql logins and so. |
|
|
|
|
|
|
Simple as restoring?