Viewing 15 posts - 31 through 45 (of 80 total)
OK thank you very much for your investigation.
I will speak to the guys who build the server and get them to do a complete domain authentication, membership and build check...
April 17, 2014 at 4:09 am
sorry for the delay....information attached
April 15, 2014 at 6:34 am
2 file attached:
VORTEX (server where link is being created)
TSUNAMI (server where link is pointing)
both tables for remote_logins were empty although i did notice a difference where TSUNAMI has a FQDN...
April 15, 2014 at 3:49 am
thanks for the answers....however, even when using a SQL Server login for the mappings (same account name on both sides, both have SYSADMIN for the test) i get the same...
April 15, 2014 at 2:48 am
thanks deepak....
i dont have R2....and cannot find the particular fix detailed in the CU5 release notes.
Do you or anyone know exactly what fix this is and whether it can be...
June 24, 2013 at 6:08 am
there are only 15 connections....rarely more than 2 active at any time
and yes....the procedure cache started at 2GB but was reduced down to 3MB once the connection memory was so...
June 18, 2013 at 4:26 am
ill check out the rCTE method for the final phase as there may well be expansion in the data set in the future....as a proof of concept this will have...
February 11, 2013 at 7:03 am
ive got over 500 queues and 15 extra data columns to compute also....would those links scale up??
ive got this running in under 20 seconds....ill look into those other methods
many thanks
February 11, 2013 at 6:50 am
ignore me....the code works!!
im an idiot and forgot to reference properly!!
thanks anyway :p
with data as
(
select TIMEFRAME_START, QUEUE_NAME, ATSTART_MAILS, REPLIED_MAILS from EGTS_OUT_EMAIL_ACTIVITY_HOURLY
WHERE RUNID=(SELECT MAX(RUNID) FROM EGTS_OUT_EMAIL_ACTIVITY_HOURLY)
and QUEUE_NAME='5 UK GOODS'
)
SELECT
t.TIMEFRAME_START, t.queue_name,
(SELECT...
February 11, 2013 at 5:59 am
very true....they really dont serve much purpose though....apart from point-in-time snapshots but for the space used....ill arrange to get them removed sharpish!!
thanks for the help 🙂
i hope this is useful...
September 28, 2011 at 7:12 am
Hello,
I have found the answer i believe. Checking the full LSN number from the differential posted above, the full backup taken at 1am the other day and the full backup...
September 28, 2011 at 7:05 am
please see attachment for msdb..backupset entries
thanks
September 28, 2011 at 6:59 am
Sorry....our backup schedule runs differentials during the week at 05:00 and fulls on Sunday at 04:00.
This is definately part of the file-system backup as that job starts at 1am every...
September 28, 2011 at 6:53 am
Viewing 15 posts - 31 through 45 (of 80 total)