Change: like this:BACKUP DATABASE AVDataTO DISK = 'Z:\SQLServerBackups\AVData.Bak' WITH
FORMAT,MEDIANAME = 'Z_AVData',NAME = 'Full Backup of AVData';
Note that backups can only be made to another hard disk, USB drive, or tape drive, not directly to a CD-R or DVD-R drive.For more details see: http://msdn.microsoft.com/en-us/library/ms191304.aspx
View changes from previous version.
(Word count: 109)