| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2006-02-27 : 11:59:36
|
| The discs on my server are filling up. I've nailed the problem and can fix it. The problem I have is that in order to fix it I need to delete some files from my discs but get an Access denied message. I am an admin on the server and have taken ownership of the files concerned to no avail. I'm now getting desperate.Some of these files are old SQL server backups that I can (at a push) delete. Anyone have any suggestions?I was thinking about somehow overwriting these backups with backups of an empty database, at least then they wouldn't take up so much room. What do people think?Thanks in advance steve-----------Oh, so they have internet on computers now! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-27 : 12:41:19
|
| Have you checked if these files are being held open for some reason?Go to Computer Management, System Tools -> Shared Folders -> Open FilesIf any of your files are in the list, just close them, then you should be able to delete them.. |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2006-02-28 : 00:58:06
|
| Hi,see if you can schedule backup and enable option of "DELETE BACKUP OLDER THEN ...." BTW what error it gives while you try to delete it manually ?1RegardsAndy DavisSql Shield Team--------------------------------------------SQL Server Encryption Softwarehttp://www.sql-shield.com |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-28 : 03:52:17
|
| OK there are no open files. The error I get is Access Denied which really confuses me as I know I am an administrator of the box. Unless I've missed something blindingly obvious (which is quite possible). To add insult to injury my main machine (the only one that can remotely access the server) has now completely died. I must have done something really bad in a previous lifesteve-----------Oh, so they have internet on computers now! |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-28 : 04:42:48
|
| I don't understand this. I sorted it by logging in as the local admin, but my domain account is in the local Administrators group.Many thanks to both for your helpsteve-----------Oh, so they have internet on computers now! |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-28 : 05:39:03
|
| How strange, are there any weird group policies on the machine by any chance? |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-28 : 05:59:45
|
| That's a possibility, I'll take a lookthankssteve-----------Oh, so they have internet on computers now! |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-28 : 07:02:37
|
| check the folder permissions and see who has complete control over the folder where the files are saved, then go through up the nodes until the drive letter and check if the permissions are being propagated...HTH--------------------keeping it simple... |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-28 : 08:52:09
|
| Thanks Jen, will do. That's very helpfulsteve-----------Oh, so they have internet on computers now! |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-02-28 : 09:22:10
|
| Possibly another group to which your account is a member was being denied permission.-------Moo. :) |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-28 : 12:23:24
|
Haven't been able to test it yet but it looks as though Jen might be right. The parent folder didn't have explicit permissions for the local admins group and it was created by my network admin friends. I've changed it now and will be able to test it tomorrow.Jen, we may be advertising for an assistant for me soon, you interested. Money is terrible but you get a great boss. Think of all the things you could learn too  Many thanks to all who helpedsteve-----------Oh, so they have internet on computers now! |
|
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2006-02-28 : 23:17:36
|
| Hi,just one more thing go to the parent folder and then Take Ownership of that folder,subfolder and inner content ,then it will allow you to do so.RegardsAndy DavisSql Shield Team--------------------------------------------SQL Server Encryption Softwarehttp://www.sql-shield.com |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-01 : 00:07:03
|
sounds interesting but no short rubber skirts for me eh? quote:
Originally posted by elwoos
Haven't been able to test it yet but it looks as though Jen might be right. The parent folder didn't have explicit permissions for the local admins group and it was created by my network admin friends. I've changed it now and will be able to test it tomorrow.Jen, we may be advertising for an assistant for me soon, you interested. Money is terrible but you get a great boss. Think of all the things you could learn too Many thanks to all who helpedsteve-----------Oh, so they have internet on computers now!
--------------------keeping it simple... |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-03-01 : 03:11:15
|
Thanks Andy I'll do that quote:
sounds interesting but no short rubber skirts for me eh
But what about rubber shorts?  We could make them optionalsteve-----------Oh, so they have internet on computers now! |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-01 : 03:36:32
|
before graz locks this thread, deal drop me an offer  --------------------keeping it simple... |
|
|
|
|
Not really SQL server BUT...