Re: Database Backup over the network
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 06/02/04
- Next message: Wayne Snyder: "Re: UPDATE & lock"
- Previous message: Lkitsos: "Re: SQL virus, worm or security flow????"
- In reply to: Hari: "Re: Database Backup over the network"
- Next in thread: ace rojas: "Re: Database Backup over the network"
- Reply: ace rojas: "Re: Database Backup over the network"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Jun 2004 08:05:39 -0400
The problem is still permissions... Since you are in a workgroup, you will
either have to add the SQL Server login account or SQL AGent login account
as having permissions on the Other server.
The file permissions needed for backup are those for the login that sql
server service uses (when the backup is being done in SEM or Query
Analyzer), and the permissions are those that SQL Agent uses when the backup
is scheduled...
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Hari" <hari_prasad_k@hotmail.com> wrote in message news:OlVlyMGSEHA.3140@tk2msftngp13.phx.gbl... > Hi, > > Try doing this:- > > 1. Have a common OS user in both systems, Say name of the OS user is > backupuser. > 2. Start the MSSQL Server and SQl Agent service using backupuser > > How to do that: > > So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice-- > Double click and select the "Log on" option. There you give a the backupuser > and password to start the service. > Now stop and start the MSSQL Serevr service. > > 3. Give the necessary privileges (write) in the remote machine directory > and share. > > 4. After this you try to execute the Backup database command in Query > Analyzer:- > > Backup database <dbname> to > Disk='\\RemoteServername\share\folder\dbname.bak' with init ( With init will > overwrite the backup file every time) > > I think this will definitely work out. > > Thanks > Hari > MCDBA > > > "ace rojas" <acerojas3@yahoo.com> wrote in message > news:B588771A-EB3A-4E0A-A438-238BB7D7102D@microsoft.com... > > I've read in some threads that it's possible to backup a database on a > network shared folder using this.. > > > > Backup Database temp to disk = "\\servername\shared_folder\temp.bkp" with > init > > > > I have tried this first using a local folder and it succeeds but when I > try to do the backup on a network shared folder, the backup fails saying > unable to find backup device. I already made sure that the shared folder > gives read/write access to 'Everyone" on the sharing option. By the way, the > pcs are configured only as workgroup. I read in one thread that you have be > in a domain to be able to do this. > > > > hope to get help from you guys > > > > thanks, > > ace > >
- Next message: Wayne Snyder: "Re: UPDATE & lock"
- Previous message: Lkitsos: "Re: SQL virus, worm or security flow????"
- In reply to: Hari: "Re: Database Backup over the network"
- Next in thread: ace rojas: "Re: Database Backup over the network"
- Reply: ace rojas: "Re: Database Backup over the network"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
