5,329 reputation
1129
bio website mikefal.net
location Colorado
age 40
visits member for 2 years, 1 month
seen 15 hours ago

I am a database administrator in Denver with a passion for playing music and enjoying sake. I have 10+ years of SQL experience, 3+ of Oracle experience, and a music performance degree from CU Boulder. I also play bass trombone in a local jazz band and occasionally sub in for a couple community orchestras.


15h
reviewed Approve suggested edit on How to Move All tables from one Database into Different Database?
15h
reviewed Reject suggested edit on SQL Server 2008 - How to schedule a copy of view to another database?
1d
reviewed Approve suggested edit on What are the main differences between InnoDB and MyISAM?
1d
reviewed Approve suggested edit on What are the main differences between InnoDB and MyISAM?
1d
reviewed Approve suggested edit on What are the main differences between InnoDB and MyISAM?
2d
comment Fixing a corrupt Log File in small downtime window
When you backup the database, you're backing up the data and the log file both. The log file is required for phase 2 and 3 database recovery, which is done whenever a database is brought online. I have added instructions on how to attach and rebuild the log to the answer. This works, as I have done it several times in the past. The risk is you essentially throw out your log file, but as long as your database isn't changing between backup and detach, you should be fine.
2d
revised Fixing a corrupt Log File in small downtime window
Added ATTACH_REBUILD_LOG example
2d
answered SysAdmin server role and Active Directory Groups
2d
revised Fixing a corrupt Log File in small downtime window
added 1 character in body
2d
answered Fixing a corrupt Log File in small downtime window
Apr
21
revised sql statement in access that group items and count their sum
edited title
Apr
21
comment Get into SQL Server 2008 with no management studio and no sqlcmd
osql was replaced by sqlcmd and is deprecated in SQL 2012.
Apr
21
answered SQL Server 2012 - cannot login
Apr
21
comment SQL Server 2012 - cannot login
Which edition of SQL Server, Dev, Standard, Express? Also, are you trying to connect remotely or locally?
Apr
20
awarded  Enthusiast
Apr
19
answered How do I transfer logins from 2008R2 to 2014 with passwords?
Apr
19
reviewed Approve suggested edit on Mysql join two tables and limit by first input?
Apr
17
reviewed Reject suggested edit on Can't force mysql to use index
Apr
16
reviewed Reject suggested edit on How do I restore a SQL backup, while excluding a specific table?
Apr
15
comment Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery
Unfortunately, no. It's stored in the metadata of the database. To alter it, the db needs to be online and attached somewhere. Another alternative is to ask for a backup file of the database. You can work around some of this more easily if you're doing a database restore instead of an attach.