Viewing 15 posts - 46 through 60 (of 242 total)
did you restore database on some other server.. ?
January 3, 2019 at 9:26 am
I have created a job with the following code to track whats going (run every minute). above options are good however you have to check em daily/hourly/ whenever, I found...
January 3, 2019 at 8:04 am
there is much more to learn
sqlcmd.exe and/or SQLCMD mode
December 20, 2018 at 7:45 am
is email setup correctly..
use msdb
go
SELECT items.subject,
items.last_mod_date
,l.description FROM dbo.sysmail_faileditems as items
INNER JOIN dbo.sysmail_event_log AS l
ON items.mailitem_id = l.mailitem_id
December 18, 2018 at 12:32 pm
another one.
DECLARE @path VARCHAR(8000)
declare @trcfile table (path varchar(8000))
declare @loc varchar(8000)
SELECT @loc= 'dir /B "' + replace(cast(SERVERPROPERTY('ErrorLogFileName') as varchar(255)),'ERRORLOG','') + '*.trc"'
insert into @trcfile
exec...
December 12, 2018 at 12:17 pm
not really, the best you can get is what is in the default trace using query below or from disk usage report
SELECT TE.name AS [EventName] ,
v.subclass_name ,
...
December 12, 2018 at 9:33 am
one port per instance... per box. , you can not have the same port number if it is being using by something else (including mirroring), and since instance are located...
December 11, 2018 at 11:10 am
can you try connecting using listener IP instead of listener name, after fail-over to see if works..
December 11, 2018 at 10:13 am
I would say try on your test environment and let us know the results, I too want to know if it works, if it does not then you might need
December 11, 2018 at 9:11 am
I suspect after the fail-over if DNS does not get updated you wont be able to connect because the listener will be pointing to old IP, I have seen this...
December 10, 2018 at 1:44 pm
when you assign IP address it is going to be there, heart beat or public network doesn't matter, use host file on your backup server and see if it helps.
December 10, 2018 at 10:32 am
spend some time and you will find out, I use separate drives regardless of SSD or spin drive just to maintain standard in environment. it does make things easier, I...
December 7, 2018 at 12:34 pm
query master.dbo.database_mirroring table to find out, or may be create a snapshot on sec mirror and compare ..
December 6, 2018 at 8:50 am
Viewing 15 posts - 46 through 60 (of 242 total)