5,225 reputation
1129
bio website mikefal.net
location Colorado
age 40
visits member for 2 years, 1 month
seen 3 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.


14h
awarded  Enthusiast
1d
answered How do I transfer logins from 2008R2 to 2014 with passwords?
1d
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.
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
Again, this has nothing to do with security. This has to do with the attach process and how it has to record metadata about the attach.
Apr
15
answered Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery
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
For clarity's sake, what version of SQL Server (select SERVERPROPERTY('ProductVersion') would be best) are you trying to attach the database to?
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
This isn't an access issue. The problem is that you are attaching the database to a higher version of SQL Server than the instance the .mdf was originally attached to and it's read only. SQL Server is trying to upgrade the database as part of the attach and can not because the db is in read-only mode.
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
Is the database attached and just not in a fully online state at this point? Or are you completely unable to attach it? If it is attached, what state is it in?
Apr
15
reviewed Approve suggested edit on galera tag wiki
Apr
15
reviewed Approve suggested edit on Get first login-Hit on huge table
Apr
15
reviewed Approve suggested edit on Which version of linux OS has support for MongoDB installation?
Apr
15
reviewed Reject suggested edit on neo4j tag wiki excerpt
Apr
15
reviewed Approve suggested edit on Programatically copying data from table from offline database to online database
Apr
15
reviewed Approve suggested edit on How slow is slow in postgres?
Apr
15
reviewed Approve suggested edit on How to use Select query just right after Insert on master in a query.?
Apr
15
reviewed Approve suggested edit on Select one single row from table b for each row from table a
Apr
15
reviewed Approve suggested edit on data warehouse design help