In the event of a process or user error, you have a copy of
the backup already on the server. You don??™t need to search for a backup tape, which is an overall slower
restore process in most cases.
Mapped Network Drive Letter
In previous versions of SQL Server, mapped drive letters didn??™t appear in the fileselection
dialog when choosing a backup file location; under SQL Server 2005, they do.
The problem is that when you??™re configuring a backup, you see the network drives that
are mapped for that particular session. The backup will work if you test it, but once SQL
Server returns to running as a service, the backup will fail if the same drives aren??™t
mapped in the context of the SQL Server service account. You can work around that
potential problem by simply mapping your backup drives using an XP_CMDSHELL job once
SQL Server starts.
When writing backups directly to network shares, the advantage of using a drive letter
is similar to using a backup device??”you now have a logical reference to the share. If
you need to move the share to another server, you only have to change the drive mapping,
not the backup job itself.
Pages:
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88