Please help me how to get the information who did restarted SQL services!Thanks in advance,DBADBAAll replies (5)Monday, February 13, 2017 1:18 PMLook in Windows System Event log for an Event ID 7035 like this to find the culprit:Event Type: Information Event Source: Service Control Manage...
Is there a nice way for a DBA to get alerted/notified as and when a database is not accessible for any reason(say offline,suspect,restoring...) DBA has to get alerted. I am working on sql2k5 and sql2k8 environments.Also looking for a solution which work across all Edition and not ...
If you are pointing for sql server service who restarted- then what is the error message you got or on what basis you are telling,because you if recycle of error log did you see then that is an wrong assumption.there are many ways to find out so for sql server services restart by ...
I take a backup of the DB from the source system and restore that to the new system. My question is, how will this affect the Index fragmentations on the DB that is restored on the new server. Will it change the fragmentation for the Indexes on the new server or rebuild the indexes ...
I decided to perform the dbcc checkdb becos i seen the below msg from the error logs: The Database ID 23, Page (1:11760), slot 1 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE. This...
Sql Command To Restart SQL Express Service SQL database mail authentication SQL error 17113 while starting the the Server in Single User mode SQL Error 17187 Severity: 16, State: 1 SQL error logged in Windows event log: Error 4014, Severity, 20, State, 13. MSG: A fatal error occurred.....
The windows event log only retains entries for a certain time period or to a certain size. You might be able to find entries on when it stopped at, in your log directory. It might be in C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log Look for files name SQLAG...
Today I found on SQL Server that my job is running slow from as usual. When I tried to see execution plan , I found below output in which Remote Scan cost is 97%. How should I resolve it? All replies (2) Tuesday, February 27, 2018 9:53 AM Remote Scan is due to access a linke...
I think you will be better of moving the single table to the new database, then delete it from the original db and then issue backup this and restore on the new server..How big is the database?Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/...
Want to see the blocking. Can you run this query and post the results?prettyprint 複製 SELECT des.session_id , des.status , des.login_name , des.[HOST_NAME] , der.blocking_session_id , DB_NAME(der.database_id) AS database_name , der.command , des.cpu_time , des.reads , de...