Reputation
238
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 2 7
Newest
 Yearling
Impact
~62k people reached

  • 0 posts edited
  • 0 helpful flags
  • 5 votes cast
Jul
28
asked SSIS Custom Task with a default Task UI
Jan
30
awarded  Yearling
Sep
24
awarded  Autobiographer
Jul
9
awarded  Nice Question
Feb
27
awarded  Popular Question
Aug
20
awarded  Famous Question
Dec
14
awarded  Notable Question
Sep
28
awarded  Popular Question
Jun
15
comment Setting up a Redundant Sql Server 2008 Configuration While Retaining High Performance and Minimal Downtime
We can only cluster on one SAN, which will not buy us any more recoverability in the event of a SAN failure than the snapshot system provided by the hosting company. DFS would allow us to have clustering across sans, but is not PCI compliant.
Jun
15
asked Setting up a Redundant Sql Server 2008 Configuration While Retaining High Performance and Minimal Downtime
May
12
awarded  Scholar
May
12
accepted Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling
May
12
awarded  Student
May
12
awarded  Supporter
May
12
comment Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling
Sankar, thanks for your input. I had thought that doing an hourly backup of certain tables (leaving out tables that don't change that often) might be a better approach to save some backup time on hourly backups. The big issue here is I really want 15 minute transaction log backups because data loss in our situation could have legal ramifications. As for the full backup frequency, hourly would be best, but I am afraid to tax the system too much. I did look at that script before posting, but I haven't had a chance to try it.
May
12
comment Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling
So I should change the daily statistic updates to weekly?
May
12
comment Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling
The current database is over 30 GB's, so I thought a shrink would help. Thanks for your input, Endy.
May
12
asked Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling