Viewing 15 posts - 1,426 through 1,440 (of 6,400 total)
October 4, 2017 at 1:20 am
fn_dump_dblog will be the table valued fuction to go for
select *
from fn_dump_dblog (NULL,NULL, N'DISK', 1, <PATH TO TRN>, DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT)
From that you can see the transactions...
October 3, 2017 at 5:22 am
October 2, 2017 at 1:09 am
September 29, 2017 at 6:48 am
September 29, 2017 at 6:36 am
Add the collate clause to the join to force a collation, something like
SELECT p.primary_server,p.primary_database, s.secondary_server,
s.secondary_database, p.last_backup_file, p.backup_threshold,
p.last_backup_date, s.last_restored_file, s.restore_threshold, s.last_restored_date,
s.last_restored_latency
FROM [WIN-54LA5NP2I65\PRIMARYSQL].msdb.dbo.log_shipping_monitor_primary p...
September 29, 2017 at 1:04 am
Create an alert for Error 19406 which is the replica state change, so you get the alert for primary_normal, primary_resolving, secondary_normal etc etc
September 28, 2017 at 6:34 am
Ed Wagner - Tuesday, September 26, 2017 12:58 PMCheese
Wheel
September 27, 2017 at 6:16 am
Microsoft change the certifications as and when they want.
2012/2014 had a generic MCSA as they combined the tracks for MCSA, with specific MCSE's so you had to do a...
September 27, 2017 at 3:44 am
i have three node cluster servers environment.
i am planning ssrs to existing server.
can...
September 27, 2017 at 12:51 am
DesNorton - Tuesday, September 26, 2017 8:49 AMDark
Guinness
September 26, 2017 at 8:54 am
September 26, 2017 at 7:02 am
Does anyone have a sysadmin account that still works? If so get them to change the password for you.
Otherwise if you have lost all sysadmin access, you will...
September 26, 2017 at 5:31 am
Viewing 15 posts - 1,426 through 1,440 (of 6,400 total)