140 reputation
4
bio website idatasolutions.co.za
location South Africa
age 30
visits member for 1 year, 4 months
seen Jul 12 '13 at 10:44

Mar
4
comment Performing a Transaction Log Backup on a Live Database
Thanks for you comments guys. i have set the transaction log backups to take place every hour it seems to have fixed the problem
Mar
4
asked Performing a Transaction Log Backup on a Live Database
Feb
13
awarded  Scholar
Feb
13
accepted Should I use Asynchronous Mirroring?
Feb
13
comment Should I use Asynchronous Mirroring?
Cant use AlwaysOn because we are using SQL Server Standard edition.... lokks like i'm going to have to use mirroring
Feb
13
comment Should I use Asynchronous Mirroring?
yes the servers are in different geographic locations and should anything fail we would have to be able to restore data to the latest point before the failure took place. If there is a possibilty of data loss with asynchronous mirroring then i won't be able to take that risk.... i will look into the AlwaysOn option :)
Feb
13
awarded  Student
Feb
13
asked Should I use Asynchronous Mirroring?
Dec
5
awarded  Supporter
Dec
3
comment SQL Server Maintenance Plan multiple database backups in a single folder
Then you are going to have to create separate maintenance plans for each database and direct the backups to the individual folders
Dec
3
awarded  Teacher
Dec
3
answered SQL Server Maintenance Plan multiple database backups in a single folder
Nov
28
answered limiting sql server backups inside .bak file