|
|
|
|
You can backup over the network. I prefer to use UNC paths because mapping drives under SQL Server can cause some weirdness (Hmm... maybe an article on that).
My favorite method is to not even muck with backup devices:
BACKUP DATABASE Foo TO DISK = '\\myserver\myshare\foo.bak' WITH INIT |
|
|
|
|
|
|
Submitted By :
Nayan Patel
(Member Since : 5/26/2004 12:23:06 PM)
|
 |
|
|
Job Description :
He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |
|
View all (893) submissions by this author
(Birth Date : 7/14/1981 ) |
|
|