352 reputation
29
bio website
location
age
visits member for 2 years, 3 months
seen yesterday

Oct
23
asked Is there a way to suppress DBCC TRACEON/OFF messages in the Error Log?
Aug
18
comment Failover Cluster Diagnostic Logs
I was opening it in SSMS just as an XEL. However using that function works and shows data. Thanks again.
Aug
18
comment Failover Cluster Diagnostic Logs
Thomas, do you know why/how the file can be 100MB but appear empty when opened in SSMS?
Aug
18
comment Failover Cluster Diagnostic Logs
Yes, we need to increase the root mount point but it will be a while before we can do that. Thanks for the solution.
Aug
18
accepted Failover Cluster Diagnostic Logs
Aug
18
asked Failover Cluster Diagnostic Logs
Aug
9
answered “WITH REPLACE” Restore failing with same logical filenames
Aug
9
comment “WITH REPLACE” Restore failing with same logical filenames
I found this article which explains my situation entirely: blogs.msdn.com/b/ialonso/archive/2012/06/08/… Thoughts?
Aug
9
comment “WITH REPLACE” Restore failing with same logical filenames
Aaron, thank you for the comments. I thought that if the logical filenames (not the physical filenames) matched on the database you were replacing that SQL server would automatically put the files into the same paths as the existing database (not the paths stored in the backup file). I've successfully done this before (going from SQL 2008 backup to SQL 2008 server) but now I'm not sure if the physical filenames matched as well as the logical names. My automated restore SPROC does look at FILELISTONLY and attempt to determine if a WITH MOVE statement is required. I may need to tweak it.
Aug
8
asked “WITH REPLACE” Restore failing with same logical filenames
Jul
29
comment sqlcmd returning NUL instead of NULL for tinyint column
So is there a way to make it NULL instead of NUL? Not that it matters anymore, but I'm still curious.
Jul
25
comment sqlcmd returning NUL instead of NULL for tinyint column
ypercube, I don't believe so since every other column that has NULL values is displayed correctly as NULL. It's only this one column.
Jul
25
comment sqlcmd returning NUL instead of NULL for tinyint column
I ended up using a Powershell script to get rid of the NULL and NUL values since I was going to BULK INSERT the results back into a table. Ex: (get-content $FILE) | foreach-object {$_ -replace ",NUL[L]*", ","} | set-content $FILE
Jul
25
asked sqlcmd returning NUL instead of NULL for tinyint column
Jul
22
accepted Can you upgrade a single SQL Server 2008 Failover Cluster Instance to SQL Server 2012?
Jul
22
answered Can you upgrade a single SQL Server 2008 Failover Cluster Instance to SQL Server 2012?
Jul
2
awarded  Curious
Jun
25
asked Complete Failover Cluster Failure SQL Server 2012
Jun
20
awarded  Notable Question
Jun
14
awarded  Self-Learner