CHAPTER 2 n MAKING DATABASE BACKUPS 22
The syntax for the basic command is exactly the same as for a local disk file. Simply
change to the mapped drive letter:
BACKUP DATABASE ADVENTUREWORKS
TO FILE='G:\Data\AdventureWorks_Full.bak'
UNC Share
Although it doesn??™t have the advantage of a logical reference that a mapped drive does,
backing up directly to a Uniform Naming Convention (UNC) path is the preferred
method of backing up to a network resource. The syntax remains the same as with a local
or mapped network drive:
BACKUP DATABASE ADVENTUREWORKS
TO FILE='\\Fileserver\Data\AdventureWorks_Full.bak'
Be sure that the SQL Server service account has permission to write files on the network
share.
nTip For a long time, backing up directly to network shares was ill advised. Despite the advantage of
immediately moving the backup file off of the server, a single hiccup could corrupt the entire backup file.
Network technology continues to advance, and while I have issues with backing up to a file share via a
wireless network connection, a gigabit/second network connection directly to the file server may be a reasonable
approach.
Pages:
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89