ComITSolutions (5/12/2009)
When my application starts, Physical files back-up is taken(auto).
Do you mean that you just copy the database files (mdf and ldf) somewhere for a backup? Do you stop SQL or detach the database to do this?
Could you please guide the kind of Back-up Plan that I can Introduce.
As well as Paul's link, start with SQL Books Online, the section BACKUP DATABASE
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability