backups-mapped drives wont show up

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 2000 Forums

SQL Server Administration (2000)

backups-mapped drives wont show up

Author

Topic

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-13 : 17:34:59

Hi friends
I am trying to create a backup job on sql server 2000 server.
I want backup files to be on different machine.I created a mapped drive thr windows explorer.
when i open sql server (destination path on sql server back wizard screen) i dont see the mapped drive.it only displays current machine drives but not the mapped drive.
i even tried giving unc path but no luck.

following is t-sql from my sql job

BACKUP DATABASE [Proj_tracker] TO DISK = N'\\sun\shared\Project\Tracker\DataBackup\projtrackerat10am' WITH INIT , NOUNLOAD , NAME = N'Proj_tracker backup', NOSKIP , STATS = 10, NOFORMAT DECLARE @i INT

any ideas plz
--
cheers

Cheers

gwhiz
Yak Posting Veteran

78 Posts

Posted - 2004-07-13 : 17:41:37

Mapped drives will not show up through the interface nor can you use mapped drives. But you should be able to use UNC paths to backup the database just be sure that the account that is running SQL and SQL Agent has permissions to the UNC in question.

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-13 : 17:51:34

Hi gwhiz
thanks for the quick reply.
following is error msg from my job history.

The job failed. Unable to determine if the owner (NZSOFT\Administrator) of job Proj_tracker backupat10am has server access (reason: Could not obtain information about Windows NT group/user 'NZSOFT\Administrator'. [SQLSTATE 42000] (Error 8198)).

as far as i know 'NZSOFT\Administrator' has full access to the drive i want to copy.anyway how can i find out whether this user has full access rights.
Thanks

Cheers

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-13 : 17:53:22

i was able to create files and delete them on the mapped drive thr windows explorer (ofcourse login user is 'NZSOFT\Administrator' ) so that means this
user has full rights,right?

Cheers

gwhiz
Yak Posting Veteran

78 Posts

Posted - 2004-07-13 : 18:10:05

What account are the MSSQLServer service and the SQL Agent service running under?

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-13 : 18:20:06

i selected sql agent in EM and clicked on properties
and this account radio btn is selected and account is 'NZSOFT\Administrator'

Cheers

gwhiz
Yak Posting Veteran

78 Posts

Posted - 2004-07-13 : 18:37:16

Where is the location you are trying to copy to another Windows 2000 Server? Is 'NZSOFT\Administrator' a local or domain account?

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-13 : 18:55:19

it is a domain account and yes,other server is also a win2k machine.
the sql server machine loggin account is programming\administrator

Cheers

gwhiz
Yak Posting Veteran

78 Posts

Posted - 2004-07-13 : 19:09:11

Does the account programming\administrator have rights to the other server?

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-13 : 19:10:07

should be ,may b i'll give a try.

Cheers

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-13 : 21:40:54

Hi gwhiz
I tried that but i got a message saying account could not be verified do u still want use it.
I tried other domain users i know but to no avail.
Still the job fails??

Cheers

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-13 : 22:12:18

following is the error msg from job history

The job failed. The Job was invoked by User NZSOFT\administrator. The last step to run was step 1 (Step 1).

and this is from sql server log file

BackupDiskFile::CreateMedia: Backup device '\\jupiter\shared\Project\Tracker\DataBackup\projtrackerat10am' failed to create. Operating system error = 1326(error not found).

Cheers

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-13 : 22:27:15

I have MSDE installation on my machine and sql agent runs under system account.
when i run same scipt (i.e following) it worked fine (my local installation has a copy of our db)

BACKUP DATABASE [Proj_tracker] TO DISK = N'\\jupiter\shared\Project\Tracker\DataBackup\projtrackerat10am'
WITH INIT , NOUNLOAD , NAME = N'Proj_tracker backup', NOSKIP , STATS = 10, NOFORMAT

i am wondering why it is failing on actual sql server machine.I even tried using my account to start sql agent but to no avail.
--
cheers

Cheers

gwhiz
Yak Posting Veteran

78 Posts

Posted - 2004-07-14 : 12:59:01

Wow. I really am stumped on this one I would have expected MSDE running under the system account to fail for sure. Just a thought here are the accounts you are using to run SQL and Agent administrators on the DB box?

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-14 : 16:39:51

sorry gwhiz
i could not understand ur question.can u be specific plz

Cheers

gwhiz
Yak Posting Veteran

78 Posts

Posted - 2004-07-14 : 16:42:58

Sorry. What I mean is are the accounts NZSOFT\Administror and programming\administrator in the local administrators group on the SQL box?

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-14 : 16:47:26

I think so.anyway can u tell me how to check that plz

Cheers

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-14 : 17:13:11

i went to administrative tools>>and selected Computer management tool
i clicked on local users and groups and in that list
i dont see 2 entries for NZSOFT\Administror and programming\administrator
but i see an entry as "Administror"

Cheers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources