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 |
|
victord
Yak Posting Veteran
64 Posts |
 Posted - 2002-04-17 : 08:56:36
|
| Dear Folks,how do i go about backing up a database to a network server.The server on which the database originaly resides is almost full and will soon undergo a rebuild. Therefore i am trying to look for an alternative backup medium/procedure, apart from the daily tape backups.Any suggestion would be appreciated.Thanks,Victord |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-04-17 : 09:08:11
|
| See if this FAQ entry from my site helps:http://vyaskn.tripod.com/administration_faq.htm#q17--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-17 : 09:09:24
|
You should be able to create a disk device using the universal naming convention for the @physicalname argument ...quote:
If the backup is to be performed over the network to a disk on a remote computer, use the universal naming convention name (UNC) in the form \\Servername\Sharename\Path\File to specify the location of the file. As with writing files to the local hard disk, the appropriate permissions needed to read or write to the file on the remote disk must be granted to the user account used by SQL Server.Because backing up data over a network can be subject to error, verify the backup operation after completion.--BOL, SQL Server 7
<O> |
|
|
|
|
|
|
Backup Tricks