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.
Author |
Topic |
Catchitbaby
Starting Member
2 Posts |
Posted - 2014-04-21 : 15:08:41
|
We have two Server's
In one server Application(ASP.net Website) is Running and In Second server Database(SQL 2005) is running..
Previously both Application and Database running on Same Server and I can make backup using this command
backup database TESTDBNAME to disk='PATH'
can someone suggest me how i can get rid of current situation
Thanks |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-04-21 : 15:31:32
|
The path is in the SQL Server's perspective, so you would still use the same path as before unless you wanted to back it up to a different server. In that case, then use a full UNC path for a resource that the SQL Server service has access to.
Tara Kizer SQL Server MVP since 2007 http://weblogs.sqlteam.com/tarad/ |
 |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-04-22 : 01:38:35
|
Depending on the size of the database and network speed , take into account the extra time the UNC path backup may take.This could be a factor if it is a time duration sensitive task
Jack Vamvas -------------------- http://www.sqlserver-dba.com |
 |
|
|
|
|