Viewing 15 posts - 676 through 690 (of 1,640 total)
ganasulochana (3/28/2013)
If the database is in Full recovery model then you can able to take the log backup.
for simple recovery mode, when it will do the checkpoints?
March 28, 2013 at 10:18 am
Thanks all, so I think I remember it wrong,
What is correct should be:
Backup transaction log is only mark part of transaction log file active, so it could be reused, and...
March 28, 2013 at 10:08 am
Eugene Elutin (3/19/2013)
sqlfriends (3/19/2013)
Also for domain tables shall I just: City, County...
March 19, 2013 at 5:47 pm
For my case, do you think if I use above grant to schema permissions, it is better to create a customized role first?
Thanks
March 14, 2013 at 12:08 pm
Chris Harshman (3/13/2013)
sqlfriends (3/13/2013)
...They may need to read and write and also execute stored procedures in the databases...
Typically when it comes to security you want to grant the least privileges...
March 14, 2013 at 11:24 am
Chris Harshman (3/13/2013)
sqlfriends (3/13/2013)
...They may need to read and write and also execute stored procedures in the databases...
Typically when it comes to security you want to grant the least privileges...
March 13, 2013 at 1:13 pm
dan-572483 (3/12/2013)
Good general rule: Jobs that need to run once but NOT more than once should not be scheduled between 1 & 3am on Sunday mornings.
But I don't think any...
March 12, 2013 at 12:56 pm
So maybe I should conclude as this;
for jobs scheduled on both daylight saving starting day and end day , I should be proactive to adjust jobs that scheduled between 1:00am...
March 12, 2013 at 12:05 pm
Also if according to spring forward, fall back, if job scheduled to 1:40 am for example, there could be problem in fall too. In fall, it will move 2 to...
March 12, 2013 at 11:56 am
the job is scheduled at 2:00 am on 3/10/2013
March 12, 2013 at 10:02 am
george sibbald (3/7/2013)
Not sure I understand you:
You cannot be doing OS and SQL upgrades that often for this to be a problem?
you mentioned OS upgrades and new sql server versions...
March 7, 2013 at 10:36 am
george sibbald (3/7/2013)
upgrade test, test until you are happy
upgrade prod. If its a virtual, take a snapshot before the upgrade as a quick backout.
You...
March 7, 2013 at 10:12 am
Viewing 15 posts - 676 through 690 (of 1,640 total)