Viewing 15 posts - 16 through 30 (of 317 total)
Per Kendra Little on Brent Ozar's site:" you can reorganize for a while and then stop without facing a massive rollback"
November 25, 2014 at 10:06 am
Brandie Tarvin (11/21/2014)
sqldriver (11/21/2014)
Every application I support uses SQL logins, and they all require at minimum the dbcreator role assigned.
Yikes! What kind of application spawns its own databases? And how...
November 24, 2014 at 5:55 pm
ScottPletcher (11/20/2014)
App passwords are a different matter, and it can depend on the app. But stored passwords...
November 24, 2014 at 5:46 pm
How fragmented are the indexes on the tables?
Were you doing online index rebuilds?
November 24, 2014 at 3:03 pm
Is this a third party application?
What is the purpose of the subscriber database?
How many tables are being dropped/recreated or having their PK modified.
One option is to drop the articles for...
November 18, 2014 at 4:57 pm
You connect to the SQL Server instance on Server2 from the publisher using the credentials that the merge agent uses via either SSMS or SQLCMD.
November 18, 2014 at 9:39 am
If you shrink the data file, you must rebuild your indexes in order to fix the fragmentation.
Leave enough space for the index rebuild (approx. the size of the largest table).
November 17, 2014 at 5:24 pm
You may need to change the -LoginTimeout and -QueryTimeout parameters for the MergeAgent.
You can either change the profile or modify the Merge Agent job itself.
November 17, 2014 at 5:16 pm
This is your problem:
2014-11-17 06:04:28.077 The process could not connect to Subscriber 'SERVER2'.
2014-11-17 06:04:28.146 Connecting to Subscriber 'SERVER2'
2014-11-17 06:04:28.171 Category:AGENT
Source: SERVER2
Number: 20084
Message: The process could not connect to Subscriber 'SERVER2'.
2014-11-17...
November 17, 2014 at 5:13 pm
We are always trying to expand and update our knowledge, otherwise we quickly start to lose ground.
Currently I am trying to understand how best to run SQL Server on HyperV...
November 17, 2014 at 11:52 am
We need more info on your requirements:
Are these databases in the same location or do you need to sync over a WAN?
Are these database pairs or are we talking about...
November 10, 2014 at 9:51 am
Check to see some one is doing something stupid like shrinking files.
Check if statistics are being kept up to date?
Are indexes fragmented?
Is there some kind of index maintenance?
Are there sort...
November 7, 2014 at 5:58 pm
Here is a script that gives you the most recent full that is less than seven days old for a given database:
declare
...
November 7, 2014 at 5:49 pm
You could use mirroring and and a daily snapshot for read-only access.
Log shipping is another option.
How big is the .mdf file compared to the rest of the db?
November 7, 2014 at 10:21 am
Depends on your system and how long his will take.
Are you running enterprise edition and are you planning to rebuilh with online option?
Have you run this in test?
November 6, 2014 at 2:30 pm
Viewing 15 posts - 16 through 30 (of 317 total)