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 |
|
solart
Posting Yak Master
148 Posts |
 Posted - 2002-09-13 : 14:03:34
|
| In a non-clustered environment, I am under the impression that backups must be to a local disk or local tape device. There appears to be support for backing up to SANs, NAS, and remote disks using UNC.My plan is to have a separate disk in a clustered environment on a shared array for holding my backups, until they can be transferred somewhere else.My question is, will SQL Server 2K support backing up to the disk in the shared array since it is (I believe) not considered a local disk? What key points may I need to know.Thanks very much for the help!!solart |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-13 : 14:21:40
|
| Using TSQL BACKUP DATABASE/BACKUP LOG you can specify a UNC path.This is for all editions/all versions on SQL2000 - no config change required, its only the Enterprise Manager interface that has trouble with it. Not sure of the implications in a clustered environment however I see no problem backing up to \\server\share.HTHJasper Smith |
 |
|
|
gwhiz
Yak Posting Veteran
78 Posts |
Posted - 2002-09-13 : 18:53:55
|
| Actually volumes on a shared array are treated as local disks. We store our backups on a shared array without any problems. |
|
|
|
|
|
|
Cluster Database Backups Question