Home Forums SQL Server 2008 Security (SS2K8) backing up all databases on box, and not allowing users to access database while doing this? RE: backing up all databases on box, and not allowing users to access database while doing this?

  • Brian Seib (5/19/2015)


    Yes - I do agree. This will give a good opportunity to free up some space as well with the full backup/restore method,

    Not sure what your expectations are here. If the log file is 20 GB on the source server, it will be 20 GB on the destination server as well. But the backup will not include 20 GB of dead meat as when you detach/attach, so you will save some time on copying. But the 20 GB has to be zeroed out.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]