SQL Server Performance

Backup Device

Discussion in 'General DBA Questions' started by danny123, Dec 14, 2007.

  1. satya Moderator

    You can run INIT option with backup that will initialize the device to remove all the files, as you are taking to the same device it is not possible to drop the criteria. Simply drop the device and recreate to have full backups.
  2. rohit2900 Member

    Hi Danny,
    There is a work around for you problem...can you restore you full backup to any stand by server? If yes then take backup of that database where you have restored this backup file and delete the original backup file from your machine as you are having the full backup.....I think this should work...
    Rohit

  3. ghemant Moderator

Share This Page