I think your question is pointed to "if pages are allocated or data can be inserted when the backup is running.", if this is true, the answer is YES.

Please review these SQL Server Book Online topics

SQL Server 7.0 Books Online topics:

"Physical Database Files and Filegroups"

"Using Files and Filegroups"

"Creating Filegroups"

"Creating File or Filegroup Backups"

"Using File or Filegroup Backups"

"Restoring...

Review this thread

http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/5924074f-5f1c-444a-bd09-fc3e999f2637/

It has a interesting code there.

Regards

Here is a tutorial about it

http://www.mssqltips.com/tutorial.asp?tutorial=119

Regards

Are you using xp_cmdshell to execute your BAT file?

Here is good tutorial about backups.

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-database-backup.html

Regards

You can use SMO Object Model to implement backup script, database restore and restore scripting.

Hi

Review this article, it contains your requirements.

http://www.sqlservercentral.com/scripts/Security/66129/

You ca use Service Broker Technology to capture the Event and raise an action

Review this article and modify it according your requirement.

http://www.sqlteam.com/article/centralized-asynchronous-auditing-with-service-broker.

Use views to restrict the scope and Stored procedures to add data.

Regards

Hi

Please read this article to expand the topic.

http://www.zimbio.com/SQL/articles/1204/Database+Mail+vs+SQL+Mail+SQL+Server+2005

You can read this article to capture IO Stats

http://www.mssqltips.com/tip.asp?tip=1416

Regards

Hi

Please evaluate @nalytics Performance Free Data Collector for Microsoft SQL Server &

Windows Server, this tool can help you to solve your performance problems and get

performance archive history information...

Hi

You can use @nalytics Performance Free Data Collector for Microsoft SQL Server &

Windows Server to see what waits the instance is doing , this tool can help you to...

Hi

Please evaluate @nalytics Performance Free Data Collector for Microsoft SQL Server &

Windows Server, this tool can help you to solve your performance problems and get

performance archive history information...