**change the location of backup file**

Hi
I'd like to find a way to locate the path of my backup file in another
client or station for ,when I'm backing up one database through Enterprise
Manager on my station of our server.
In another word,as I found ,during a backup activity of DB on server
throught a client,I can just select the file location on server ,Is there
any way to locate it fore example on a client or other stations directly?
Any help would be grate.You have to type in the UNC path, such as \\servername\sharename\directory\filename.bak. The SQL
Server service account need permissions on that share.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<R> wrote in message news:opswr1sah2mw7tkz@.system109.parskhazar.net...
> Hi
> I'd like to find a way to locate the path of my backup file in another client or station for
> ,when I'm backing up one database through Enterprise Manager on my station of our server.
> In another word,as I found ,during a backup activity of DB on server throught a client,I can just
> select the file location on server ,Is there any way to locate it fore example on a client or
> other stations directly?
> Any help would be grate.|||Hi,
1.You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename­­­\dbname.bak'
with init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
SQL Server MVP
<R> wrote in message news:opswr1sah2mw7tkz@.system109.parskhazar.net...
> Hi
> I'd like to find a way to locate the path of my backup file in another
> client or station for ,when I'm backing up one database through Enterprise
> Manager on my station of our server.
> In another word,as I found ,during a backup activity of DB on server
> throught a client,I can just select the file location on server ,Is there
> any way to locate it fore example on a client or other stations directly?
> Any help would be grate.|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<R> wrote in message news:opswr1sah2mw7tkz@.system109.parskhazar.net...
> Hi
> I'd like to find a way to locate the path of my backup file in another
> client or station for ,when I'm backing up one database through Enterprise
> Manager on my station of our server.
> In another word,as I found ,during a backup activity of DB on server
> throught a client,I can just select the file location on server ,Is there
> any way to locate it fore example on a client or other stations directly?
> Any help would be grate.