Viewing 15 posts - 151 through 165 (of 356 total)
You can query backupset and look for your needed LSN between first_lsn and last_lsn.
March 2, 2016 at 11:22 am
The log in this backup set begins at LSN 171240000001726900001, which is too recent to apply to the database. An earlier log backup that includes LSN 171240000001695900001 can be restored.
It's...
March 1, 2016 at 3:47 pm
Sounds more like an ETL project than replication...
February 29, 2016 at 1:11 pm
Maybe setup a new properly architect-ed box and utilize log shipping, mirroring, or both to minimize your downtime.
To answer you original question. Can you move/copy your files and keep...
February 29, 2016 at 1:01 pm
Run sys.dm_db_index_physical_stats, is the "duplicate" due to LOB data?
February 29, 2016 at 12:09 pm
Have you considered using the VMWare technologies (vs. SQL's) to meet your DR requirements?
Might be worth a look:
February 29, 2016 at 10:33 am
Put it in single user mode
February 27, 2016 at 2:47 pm
The correlated large transition log growth would indicate a runaway query. You may want to setup a profiler trace with a filter on long query duration.
February 26, 2016 at 9:39 pm
What compatibility level are you running?
Try the two step upgrade, I've got $ it will work. (90 to 100 or 110, new backup to 120)
February 26, 2016 at 2:44 pm
Are you aware of AlwaysOn Availability Groups?
February 26, 2016 at 1:56 pm
Are you patched?
https://support.microsoft.com/en-us/kb/982854
Extended events and ring buffers have also been causing some memory strife lately...
February 26, 2016 at 1:49 pm
Are you hitting a timeout or max Remote Desktop connections?
February 26, 2016 at 1:45 pm
So a dynamic increment value is what you're looking for?
Maybe in-line this: ALTER SEQUENCE?
February 26, 2016 at 1:36 pm
Viewing 15 posts - 151 through 165 (of 356 total)