| bio | website | idatasolutions.co.za |
|---|---|---|
| location | South Africa | |
| age | 29 | |
| visits | member for | 5 months |
| seen | Apr 16 at 6:36 | |
| stats | profile views | 0 |
|
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 |