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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-10-08 : 00:27:44
|
| Dear Memberin my database access one application. more than 100 user working of this application. so it possible to give a full backup of database to live working of the user.please tell me any problem of this activity.send experience anybody do this activity. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2010-10-08 : 00:41:44
|
| thank you mam to quick replayi will do this.but is my one questionmy database backup size is 100 gb. so any effect of performance. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-10-08 : 00:49:33
|
| It can affect performance, just depends how your hardware is setup, specifically the disks. You should look into a third-party backup utility that can compress it while it is backing up, saving disk space and backup time. We use Red Gate's SQL Backup (cheap) and Quest's Litespeed (not so cheap). For our 2008 systems using Enterprise edition, we use native compression. Compressing your backups saved 75-90% of disk space and around 75% of backup time. You should really look into this.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
full backup in live database