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 |
|
trev.pope
Starting Member
1 Post |
 Posted - 2002-09-19 : 08:56:31
|
| Hi,Im more of a developer than an administrator, but recently got involved with a contract requesting me to also look after the Database server, my question is this, Im concerned about the backup, i have read many books, and bol, but i still fail to understand how to do a basic backup procedure that if the whole computer crashed and had to reload windows and SQL Server, the backup could be restored with a few clicks of a button, could anyone tell me or point me in the right direction?Thanks in advance |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-19 : 13:23:44
|
| Well, that is quite a broad topic, and it is layed out quite well in BOL (Much better than I could explain here).You take a full backup and store it either on tap or disk (Not the same disk as the DB files). Then if you have to reload windows, you use that backup file to restore your DB.Optionally, you can also take tranlog backups as well, this increases your flexability with regards to the point in time you can restore to.Play around with it a bit (On pubs). You'll get the hang of it. There are code samples in BOL. And I suggest learning the code to do the backups and restores as oppsed to using the GUI. You will understand better if you have to write the code to make it happen.-Chad |
 |
|
|
|
|
|
|
|
Database Backup