Vidhya Sagar


Hi,

Will backup get completed quickly (the time taken for backing up large databases) on backup device or using backup command If backup device, why




Re: Backup Device vs backup command

Dinakar


You are talking about 2 different things here. You use the backup command to backup the DB and the backup device to store the backed up files.
Unless I dont understand your question.





Re: Backup Device vs backup command

Vidhya Sagar

Hi Dinakar,

I need to know which one completes backup faster, backup device or by using backup command. I heard that backup device completes backup quicker than using backup command.

Thanks






Re: Backup Device vs backup command

JohDas

It's the same procedure, whether you commit it via a GUI (window menu->next->next...) or command prompt (BACKUP command) it makes no difference.

In both cases you use a backup device to backup your database. If you are a learner you'll probably use the user friendly windows menu. If you are advanced you'll probably use the SQL command: BACKUP






Re: Backup Device vs backup command

Satya SKJ

Have you checked the same on your environment

IMHO I don't see much difference in between and it makes a lot of difference betwen normal disks & RAID based ones.

BTW do you have any issues in your environment for such behaviour, if so let us know.






Re: Backup Device vs backup command

Vidhya Sagar

Hi Satya,

Im using RAID disks, when backing up 200GB of database, backup device completes faster than backup command. A 30 min difference..

Thanks





Re: Backup Device vs backup command

Satya SKJ

If SQL Server stripes physical devices that have different input/output (I/O) throughputs, SQL Server optimizes for speed. This means that faster devices receive more backup data that is written to disk than the slower device in the same period of time. In SQL Server 2000, regardless of the I/O throughput differences, SQL Server tries to distribute the backup data evenly to the devices. In this case, the slower disk may become a backup bottleneck in terms of performance. If increasing performance is your primary goal, you must avoid using the slow disk in striping and use disks with comparable throughputs instead.