Viewing 15 posts - 46 through 60 (of 92 total)
As per my current understanding you cannot use profiler or SQL server side trace ( that is what the earlier post was suggesting) to monitor windows related events.
Further a...
July 24, 2012 at 8:24 am
From MSDN:
A copy-only log backup preserves the existing log archive point and, therefore does not affect the sequencing of regular log backups.
Reference: http://msdn.microsoft.com/en-us/library/ms191495.aspx
July 23, 2012 at 1:25 pm
Building up on Steve's suggestion I would like to suggest that you can try using the following to forcefully use TCP/ IP as a protocol:
1) For Default instance, ...
July 23, 2012 at 1:06 pm
agree, and that is why we had the truncate log on checkpoint option in SQL 2000.
From my experience though there is usually not a need to perform a checkpoint explicitly...
July 22, 2012 at 9:43 am
Logging mechanism is the same with both Full and Simple recovery model , it is a bit different with Bulk-logged recovery model for some of the operations like index creation...
July 22, 2012 at 8:54 am
Robert.
and I would like to add that your blog on this issue is a excellent source of information, step by step and covering every aspect of troubleshooting. Thanks.
July 22, 2012 at 8:42 am
Basic SQL Server auditing provided by default trace provides information such as when an object was altered/created/deleted can prove very useful and is already in place on every...
July 22, 2012 at 5:50 am
Here you go
Following is a SQL 2008 security related article from Rick Byham(Microsoft)
http://technet.microsoft.com/en-us/magazine/2008.04.sqlsecurity.aspx
and following is a link to a whitepaper download ( more from a DBA...
July 22, 2012 at 3:22 am
the following may work as well, suggesting the workaround since you mentioned that it was urgent.
Execute "Select * from Tablename" in SQL Server Management studio query editor window(if...
July 22, 2012 at 3:04 am
ok i think there is no rule of the thumb and it is more subjective to how the applications works. in some cases you may also have to ...
July 22, 2012 at 2:49 am
you can also execute the following (from a command prompt) in case you want to confirm \ or rule out port access restrictions in the near future
Telnet 'hostname_on_which_sqlserver_resides' 'portno_sqlserver_is_listenign_on'
The...
July 22, 2012 at 1:40 am
I am in complete agreement with Robert.
Updating logshipping table(s) directly is almost like using a sledgehammer to drive down a nail, it is not necessary and further it may not...
July 22, 2012 at 1:19 am
Index seeks are better than Index scans but then it is also subjective to the actual data generally and in 99.9 % cases the optimizer comes up with the best...
July 22, 2012 at 1:02 am
I have a suggestion (from personal experience) for a similar scenario.
one of the ways (there are many) to confirm database related activity is to start a perfmon and check the...
July 22, 2012 at 12:25 am
Viewing 15 posts - 46 through 60 (of 92 total)