I had to reattach a Microsoft SQL 2005 database file for someone this morning. I’ve had to do it several times for this database as they are doing lots of testing for it and like to detach it, backup it up and reattach it.
This morning however, it wouldn’t let me reattach it. The management studio gave me an error 5123 trying to open or create the file. After some research it turns out to be a permissions problem.
I checked the permissions on the file and the person who had detached the file was the only one with access. So I granted Everyone full access and I was then able to reattach the database.
The other day I started getting the error “Attempting to copy to the disk <ipod name> failed” when tying to sync my music and video.
At first I thought it might have been one of the applications I had put on that save files to the iPod or that something had gone wrong with my iPod. But after doing some research on the internet it turned out to be a ‘corrupt’ album.
I had recently added three new albums to iTunes. So I unckecked those so that they would not sync to my iPod and no error! I then reselected one album at a time and tried sync’ing again to work out which album it was. This worked and I now know which album it was. However, I don’t know exactly why it was causing the error because it turns out that I don’t like the album and have simply removed it from iTunes altogether.
Someone suggested something about having brackets around numbers or it might be an illegal charcter in the name. I’m not sure.
I tried to doing an upgrade / migration from 9i to 10g that other day. It seemed to be going well but then I had to shut the machine down because of a power outage.
I had to shut it down remotely as well, so I couldn’t tell if it had finished or not. I think it may have failed because it ran out of disk space. After the outage I had a look at my server and neither database would start because the disk was full.
Hopefully I’ll get to try it again in a day or two.
It looked like I was going to have to upgrade one of our DEV databases from 10.2.0.1 to 10.2.0.4 today. I was a bit nervous about doing that so I tried it on one of my test databases first. It didn’t seem to work. Now it also seems that the issue we were having with the DEV database has gone away, it was an application issue. So I don’t really need to upgrade it now. Which is good. I might still try upgrading my test database though. The process seems different to a recent version 9 patch I did and I want to make sure it get it working and understand how it works and what happens.
I discovered last night that if you shift delete a song or video in an iTunes playlist it will ask you if you want to delete it from your library. Normally just hitting delete with a file selected in a playlist will only delete it from that playlist.