backup devices vs files in SQL7

[yatie]

If I'm not mistaken, we can create a backup device OR backup files in SQL7. Can someone tell me which one is better?

[sqlprobe]

In my experience backup devices are much quicker to backup to because SQL server has already formatted 8KB contiguous space on the Operating system and as you know backup takes place in extents, the database writes to an already formattd file(backup device) but if you backup to file the file gets formatted as the backup takes place. I also find that restores are quicker from a device

Try out my website

www.baysignia.com/discussions/discussions.xml

I am thinking about running MCBA(online) courses.

I hope this helps


------------
yatie at 6/16/01 10:57:27 AM

If I'm not mistaken, we can create a backup device OR backup files in SQL7. Can someone tell me which one is better?