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 |
|
kotsas
Yak Posting Veteran
65 Posts |
 Posted - 2002-03-29 : 02:27:57
|
| how can i put database in hot backup mode? Is there any sql commands? |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-03-29 : 09:00:25
|
quote:
how can i put database in hot backup mode? Is there any sql commands?
Oracle has Hot/Cold Backups... You should be able to backup the DB with users in it. It's when you restore that the users cannot be logged in.I have a job setup to do a complete backup at night and backup the transaction logs every hour during the day. All the backups goto a separate partition on my SQL server. This way the NetAdmin can backup the backup files to tape whenever he wants to without affecting db access in anyway.I'm not sure I really answered your question but I hope that helpsDanielSQL Server DBA |
 |
|
|
|
|
|
hot backup mode