518 reputation
27
bio website
location
age
visits member for 2 years, 3 months
seen Feb 11 at 20:33

May
1
awarded  Yearling
Feb
11
comment SQL Server Database errors 8935/8934/8977
Do you know if the last backup can run a clean checkdb? What was the output of the REPAIR_ALLOW_DATA_LOSS command? And is all the user data accessible? If it is you can create a new database and move it over.
May
1
awarded  Yearling
Apr
22
comment How do I shrink the physical Transaction Log file when it's the principal in a mirror?
Another option may be to take a diff backup and restore that to the mirror. It may not work but it's worth a try if you or anyone else runs into this again.
Mar
6
answered Manually moving SQL instance to another node causes immediate database mirror failover
Feb
27
comment Is there a better option than Union All for multiple selects from the same row?
You can try a pivot but I wasn't able to get that working for something like what you're trying. Since the project I was working on required exporting data anyway I used the pivot function in SSIS and that worked like a charm. The only thing I can think of that may be like that is writing a CLR proc that would do what you want.
Feb
27
comment SQL Server 2005 not collecting logins in the log file
I'm assuming you know logins have happened. I would do a trace to confirm they're showing up there but they probably are. Are there any errors in either the SQL or Windows logs that may be related to this?
Jan
25
answered How can I fix “Cannot perform a differential backup … a current database backup doesn't exist”?
Jan
25
comment How can I fix “Cannot perform a differential backup … a current database backup doesn't exist”?
Can you try running the script here to see if there are any other backups happening outside of what you have scheduled: jasonbrimhall.info/2012/11/30/backup-history
Jan
25
comment How can I fix “Cannot perform a differential backup … a current database backup doesn't exist”?
My first thought is that there was a SAN or VM snapshot that's causing this. However, that doesn't explain why on 1/22-1/23 the first diff after the full failed and the next succeeded with no other full. Do you mind double checking that because I would expect a new full to need to be taken to get things working again?
Jan
4
comment Easiest Way to Move 100 Databases
DatabaseBackup isn't a standard SQL proc. It's part of a free package from Ola Hallengren. If you don't want to use that you'll need to roll your own script to back them all up at once.
Jan
2
comment Tables not shown in SQL Server Enterprise Manager
Does checkdb run clean on that database?
Dec
29
answered Restore .mdf data file for a File Group in SQL Server
Dec
18
comment How do I configure SQL Server 2012 so that it can restore and see files in my user account?
The reason that SQL doesn't use the standard dialog is so you can't pick a file that SQL can't read from. As to how to configure security, are you open to changing the account that SQL runs under or do you want to leave it the way that it is now? If changing the service account is okay then this is easy to take care of. We use named accounts so I can't do testing with the generic MSSQLSERVER account to help with that.
Dec
10
comment Backup Disappearing?
Are you clicking the button next to where it says, "To a point in time:" so it no longer says "Most recent possible"?
Dec
7
answered Can't grant role permissions under sysadmin login
Dec
7
comment Cross Database transactions with Availability Groups
Right. I don't know for sure if this can happen but if the child transaction on DatabaseB commits and the transaction fails to commit on DatabaseA due to the failover what will happen. Hopefully it'll get rolled back. However, I do see room for Bad Mojo happening. Someone with a lot more knowledge about the internals than me is going to have to provide the final answer.
Dec
5
answered Cross Database transactions with Availability Groups
Dec
4
comment SQL set allowed values for a column
As a note, this is SQL Server syntax since I answered the question prior to when it had the Oracle tag and appeared to be SQL Server to me.
Dec
4
answered SQL set allowed values for a column