ComITSolutions (5/13/2009)
Yes, My application Stops Sql Server agent & SQl Server Takes Back-up(mdf and ldf files and starts SQL Server and Server Agent.
Don't. That's a very poor way to take SQL backups.
Schedule regular database backups (BACKUP DATABASE...). If point in time recovery is required, schedule regular log backups as well. Those backup files can then be copied to tape or whereever you're backing up to, with no downtime required.
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