SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2000 backup on network device


SQL Server 2000 backup on network device

Author
Message
milanvl
milanvl
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 1

I've tried to do a backup of some databases from SQL Server 2000 on network share on File server under MS Windows Server 2003. I've changed the account for MS SQL Server Agent to be a domain user account, added the network device with sp_addumpdevice stored proc., put it in built-in Sysadmin group, gave all necessary permissions according to BOL and MSDN and got nothing at all!

Does anybody know the solution for this problem?

Milan





Antares686
Antares686
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: Moderators
Points: 25552 Visits: 785
What error is it giving and however are you creating your backups?



milanvl
milanvl
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 1

I used a mapped network drive from File Server as drive F: on SQL Server machine, then added that mapped drive F: as Backup network device using stored procedure sp_addumpdevice. After that, from Enterprise Manager I tried to backup database Master using backup device 'F':.

I've got error message MS SQL-DMO (ODBC SQL State: 42000) - Cannot open backup device 'asnetwork'. Device error or device off-line. See the SQL Server error log for more details.

BACKUP DATABASE is terminating abnormaly.

In error log I've found next:

BackupDiskFile::Create Media:Backup device 'F:\asbckp.bak' failed to create. Operating system error = 5 (error not fpund).

I've also tried to manage without network mappings, using simple file path to the network share on File Server as a backup device, but with similar results.





Antares686
Antares686
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: Moderators
Points: 25552 Visits: 785

Try using the UNC path instead as the F mapped drive will not be visible to SQL Agent only the logged in user at the time the map is created.

'\\server\drive$\path\filename.bak'





A.M
A.M
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 1

Hi,

I know it's possible because someone ask me for the same thing in a long time.

With SLQ server 2000 I've enabled a specific option...but I'm sorry I don't remember the syntax of the command.

I think it was something like : "trace flag" + a specific number.

Did you look in Microsoft KB ? I've found that :KB827452

Regards,

CCzzz


Vik Nat
Vik Nat
SSC Eights!
SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)

Group: General Forum Members
Points: 868 Visits: 68
yes use a UNC share. The server you are backing up to - is that on the same domain as the DB server. Is your SQL Server running under a domain account? If your SQL Server is running under a domain user account and the server that you are backing up to is on the same domain, then you should be good. If the server you are backing up to is not on the domain, then you can create a local account with the same username/pw as the account SQL server is running in and give the account the neccesaary permissions on that server and it should work fine.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search