Profile

Cover photo
Karthick P.K
36 followers|45,556 views
AboutPosts

Stream

Karthick P.K

Shared publicly  - 
1
Add a comment...

Karthick P.K

Shared publicly  - 
 
False warning “A significant part of sql server process memory has been paged out”
In A significant part of SQL Server process memory has been paged out we discussed about SQL Server working set trim warning, when they can occur and how to troubleshoot them. I the same blog I men...
1
Add a comment...

Karthick P.K

Shared publicly  - 
 
FILESTREAM feature is disabled
Restore database (or) SQL Server setup fails in script upgrade mode with below error { Msg 5591, Level 16, State 4, Line 2 FILESTREAM feature is disabled. Msg 3013, Level 16, State 1, Line 2 RESTOR......
1
Add a comment...

Karthick P.K

Shared publicly  - 
1
Add a comment...

Karthick P.K

Shared publicly  - 
 
Bulk insert fails with error 4861 Cannot bulk load because the file could not be opened
1
Add a comment...

Karthick P.K

Shared publicly  - 
 
When you try to recover and open mirrored database using dbcc dbrecover([DBNAME]) You would get below error { Msg 7930, Level 20, State 1, Line 1 Mirroring must be removed from the database for thi......
1
Add a comment...

Karthick P.K

Shared publicly  - 
 
Trace waits in SQLServer (SQLTRACE_BUFFER_FLUSH,TRACEWRITE,SQLTRACE_WAIT_ENTRIES,SQLTRACE_LOCK
http://sqlserverscribbles.com/2013/03/04/trace-waits-in-sqlserver/
When you run Profiler trace from client systems or on server with large number of events you will see below wait types. SQLTRACE_WAIT_ENTRIES SQLTRACE_LOCK SQLTRACE_BUFFER_FLUSH TRACEWRITE There is......
1
Add a comment...
Basic Information
Gender
Male
Links
Contributor to