Hi there,
Does anyone know if it's possible to perform a MSSQL7 database backup on a network drive instead of the local drives ?
...and if yes, how to proceed ?
It seems to be possible under MSSQL2000.
Many thanks for your help in advance,
MattEach MS-SQL device must be know as a local disk to control the IO writes, and a dump device follow this rule|||many thanks for this answer ;o)|||Originally posted by fadace
Each MS-SQL device must be know as a local disk to control the IO writes, and a dump device follow this rule
It is not a true:
backup DATABASE database
to disk ='\\networkserver\BACKUP\database.bak'|||hu interresting, gonna have a try with this !! thanks !! :)
is there no read/write error risks ? I mean, if we exclude the network transmission problems, of course.|||Originally posted by mattoo
hu interresting, gonna have a try with this !! thanks !! :)
is there no read/write error risks ? I mean, if we exclude the network transmission problems, of course.
If someone cuts a network cable it should be a problem but no more.|||Fine. Many thanks again for your help ;)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment