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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-15 : 07:58:14
|
| Ralph writes "Can a production database be backed up either fully or partially simultaneously while it is being used by users. If it can be done, are there any special steps or considerations?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-15 : 08:00:02
|
| Yes, all backup types (full, differential, and log) can be done while the database is online and in use. Books Online has all the details under "BACKUP". |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-15 : 08:33:01
|
You have to take special steps only if you want to backup and make it where other users cannot use it at the same time.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-15 : 13:43:28
|
| If this is a transactional database then scheduling hourly or sub-hourly backups of the transaction log is your best bet. Your database will need to be in full recovery mode.When researching this topic, think in terms of recovery instead of backup. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-18 : 01:19:31
|
or bulk-logged (just to make the log backup work)quote:
Originally posted by jason
If this is a transactional database then scheduling hourly or sub-hourly backups of the transaction log is your best bet. Your database will need to be in full recovery mode.When researching this topic, think in terms of recovery instead of backup.
--------------------keeping it simple... |
|
|
|
|
|
|
backing up a production database in use.