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'sIn 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 commandbackup database TESTDBNAME to disk='PATH'can someone suggest me how i can get rid of current situationThanks |
|
|
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 KizerSQL Server MVP since 2007http://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 taskJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
How to backup sql Database from FrontEnd