|
Home > Archive > MS SQL Server > October 2006 > Error doing manual backup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error doing manual backup
|
|
| ricky252525 2006-10-24, 6:33 pm |
| I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
get an error trying to backup to a local drive:
Cannot verify the existence of the backup file location.
I read how this usually refers to backing up to a network share or
something, but this is a local drive. I tried it logged in to the Management
Studio as trusted and SQL authentication.
Any ideas? Thanks!
| |
| John Bell 2006-10-24, 6:33 pm |
| Hi
You may want to check backing up to a different directory, if that works it
must be ralated to the directory in which you are backing up to, such as
permissions.
John
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
>
> Cannot verify the existence of the backup file location.
>
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
>
> Any ideas? Thanks!
| |
| ricky252525 2006-10-24, 6:33 pm |
| Thanks, I tried that. Even tried to backup right to C, just for fun
--didn't work. Other suggestions?
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
>
> Cannot verify the existence of the backup file location.
>
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
>
> Any ideas? Thanks!
| |
| Tracy McKibben 2006-10-24, 6:33 pm |
| ricky252525 wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
>
> Cannot verify the existence of the backup file location.
>
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
>
> Any ideas? Thanks!
Is the SQL Server service running as a domain user or as Local System?
Which domain user? What rights does that domain user have on the local
machine?
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
| John Bell 2006-10-24, 6:33 pm |
| Hi
If you have checked/changed the service accounts as Tracy has suggested then
what message do you get if you back this up using a T-SQL script?
John
"ricky252525" wrote:
[color=darkred]
> Thanks, I tried that. Even tried to backup right to C, just for fun
> --didn't work. Other suggestions?
>
> "ricky252525" wrote:
>
|
|
|
|
|