Viewing 15 posts - 61 through 75 (of 126 total)
May 17, 2017 at 8:34 pm
4gb These days is relatively normal for a log file in a OLTP database. Especially if you are doing regular index maintenance.
just for fun, what is the result...
May 17, 2017 at 6:27 am
HA and DR are 2 different, but related things...like cousins, not twin siblings 🙂
How much disaster are you wanting to recover from? Database deleted? Server toasted? Server...
May 10, 2017 at 1:40 pm
Sorry, I'm at a loss...have not done any replication with 2016 yet 🙁
April 6, 2017 at 6:55 am
Any post-snapshot activities such as index maintenance happening on the Sub?
April 5, 2017 at 12:44 pm
recovery model?
Backups?
Full or Empty log file?
Index or stats updates/rebuilds different than the other sub?
Select db_name(database_id),log_reuse_wait_desc
from master.sys.databases
April 5, 2017 at 7:48 am
Poorly worded question, and the MUST invalidates that answer.
April 3, 2017 at 5:56 am
I have no links for you, But I currently have RDP sessions open on 4 prod servers (OLTP). Do it all the time.
February 28, 2017 at 1:43 pm
BASIC on my TI99/4(a) in the 80's
More basic in High School
moved away from computer stuff in college, except RBase for Dos
Access (I know, not a language, but...
February 24, 2017 at 7:41 am
Adding on a little...mirroring sends mistakes and "oops" moments to the mirror very quickly. With LS, you have by default 15-45 minutes (jobs are set to 15 each) to...
February 23, 2017 at 6:39 am
February 23, 2017 at 6:36 am
T-log will only hold info on things that happen to your database, such as indexing, Insert/Updates/deletes, etc. If your host is doing things to your database...run away. highly...
February 23, 2017 at 6:33 am
A SQL Runbook can be pretty much anything. I would expect to find:
February 14, 2017 at 1:54 pm
Viewing 15 posts - 61 through 75 (of 126 total)