Post reply

Backup using relative backup directory

  • November 11, 2003 at 9:01 am

    #160181

    According to the SQL Server 2000 Books Online, the BACKUP command may use a relative path name for DISK=. How does one code the BACKUP command using the relative path name?

  • November 11, 2003 at 9:09 am

    #481591

    I figured it out. If I code BACKUP DISK=pubs\pubs_db_200311111104.bak it will create my backup in C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\pubs\pubs_db_200311111104.bak

  • November 11, 2003 at 9:12 am

    #481592

    From Books Online:

    Note If a relative path name is entered for a backup to disk, the backup file is placed in the default backup directory. This directory is set during installation and stored in the BackupDirectory registry key under KEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer.

    So, there really is no reason to code a relative path.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply