Backup failure - cannot find path

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Backup failure - cannot find path

Author

Topic

aval
Starting Member

3 Posts

Posted - 2009-11-10 : 14:12:55

Windows 2003 SP2
SQL 2005 (MSDE)
RIM BPS 4.1 (Blackberry)

I'm attempting to back up the database as shown below.

I granted every account with SQL in it Full Control over the target folder. Still no luck. I am logged on with a domain account that is member of the local admins group. Tried backing up to C: also. No luck there either (possibly because certain SQL account does not have write access to it?).


C:\>osql -E
1> backup database besmgmt to disk = "C:\BUBPS\besmgmt.bak"
2> go

Msg 3201, Level 16, State 1, Server BPS01, Line 1
Cannot open backup device 'C:\BUBPS\besmgmt.bak'. Operating system error 3(The system cannot find the path specified.).

Msg 3013, Level 16, State 1, Server BPS01, Line 1
BACKUP DATABASE is terminating abnormally.
1> backup database besmgmt to disk = "C:\besmgmt.bak"
2> go

Msg 3201, Level 16, State 1, Server BPS01, Line 1
Cannot open backup device 'C:\besmgmt.bak'. Operating system error 5(Access is denied.).

Msg 3013, Level 16, State 1, Server BPS01, Line 1
BACKUP DATABASE is terminating abnormally.
1> exit



C:\>whoami /groups

GROUP INFORMATION
-----------------

Group Name                             Type             SID
                     Attributes

====================================== ================ ========================
==================== ===========================================================
====
Everyone                               Well-known group S-1****
           Mandatory group, Enabled by default, Enabled group

BUILTIN\Administrators                 Alias            S-1****
           Mandatory group, Enabled by default, Enabled group, Group owner
BUILTIN\Users                          Alias            S-1****
           Mandatory group, Enabled by default, Enabled group

NT AUTHORITY\INTERACTIVE               Well-known group S-1****
           Mandatory group, Enabled by default, Enabled group

NT AUTHORITY\Authenticated Users       Well-known group S-1****
                     Mandatory group, Enabled by default, Enabled group

NT AUTHORITY\This Organization         Well-known group S-1****
                     Mandatory group, Enabled by default, Enabled group

LOCAL                                  Well-known group S-1****
                     Mandatory group, Enabled by default, Enabled group

MYDOMAIN\Exchange View-Only Administrators Group

S-1**** Mandatory group, Enabled by default, Enabled group

Can anyone see why this is not working?

I want to try this manually before scripting something (.bat file, etc.).

aval
Starting Member

3 Posts

Posted - 2009-11-10 : 15:02:47

Must be permissions...

I was able to do this with an external USB HD:

C:\>osql -E

1> backup database besmgmt to disk = "E:\BPS1\besmgmt.bak"
2> go

Processed 1104 pages for database 'besmgmt', file 'BESMgmt_data' on file 1.
Processed 6 pages for database 'besmgmt', file 'BESMgmt_log' on file 1.

BACKUP DATABASE successfully processed 1110 pages in 9.704 seconds (0.936 MB/sec).
1>

[...]

But resulting .bak file is only 9 MB

BESMGMT.mdf is 102 MB
BESMGMT.ldf is 26 MB

Is that due to compression???

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2009-11-10 : 16:42:25

It could be that the database doesn't contain much data. The script on the link below will tell you how much space is used in each database.

Get Server Database File Information
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources