And after running that code, I tried taking a full backup and got the errors.

This is from the article I mentioned earlier:

/* STEP 1: CREATE THE DATABASE*/

USE master ;

IF EXISTS ( SELECT name

...

But I still have a 10 million row database that will not back up, same error as before.

Bottom line is that there's no pattern I can see, and I...

OK, tried adding yet another version, but 1 million rows. It's behaving ok, backup runs fine.

Also created another with 20 million rows, and it will backup fine as well!

Ok, I deleted the db and re-created it.

When I try to backup the database, I get the following error:

The operating system returned error 5(Access is denied.) to SQL Server...

Anakin,

Yes, I just created a smaller version of the same database, same kind of data, just 1000 rows instead of 10 million.

No problems, I can back it up ok. So...

Gianluca, the files MyFunkyDB.mdf and MyFunkyDB.ldf are there on the hard drive in the proper folder, same as the other databases I've created without any issues.

Also I'm able to run...

I'm unable to backup the database; I get the same "access denied" error.

This is a database I use for testing things out. This is how I loaded the data:

SELECT TOP...

Thanks, Paul, and no problem, Vedran.

I agree that asktom.oracle.com is quite helpful; I found that site quite useful when I was working with Oracle last month.

Green, that's good advice, but if you look above, you'll see that I found out the server was down; this was the reason for the error message.

I do have master set as my default database. I just don't remember having this issue before, but then I'm not used to jumping around in a lot of different...

Jim,

Thanks for you suggestion, but it's not working for me.

If I click on the database Test, the dropdown up top left (available databases) becomes grayed out. But if I...

I would get in trouble if I spend any time on...

Well, I was gonna start a new thread on the linked server issue, but whatever fiddling was done by the admins on the servers over the weekend has apparently fixed...

Jo, I'm gonna start a new thread for the linked server issue.