Can I make a backup of a live SQL 2005 Database while it's in use?
Specifically, I have a large database (96.5Gb) on my SQL 2005 Server. (I have a program that is in widespread daily use in my Chicago office that uses the SQL 2005 database). I need to make a FULL backup copy of that database to send to a fellow IT guy in our Philadelphia office so that he can mount it into a test environment that is set up there for the purpose of testing an upgrade to our program.
Can I initiate a standard SQL Server FULL database backup of that database while it is live and being used by users, or will this bring the SQL Server (and thereby also the program itself) to a crashing halt?
I don't think this matters much, but both of the servers (the SQL server and the application server) are both in a VMware environment as guests.
Thanks in advance for any and all input.