- Posts: 24
- Liked: 2 times
- Joined: Sep 21, 2009 9:30 pm
- Full Name: Patrick Parks
Because of a lack of hardware, I'll most likely be installing Veeam on a workstation class box, with a few large disk drives and backing up via the network with a 1Gbps ethernet link.
At present, we don't have a license for SQL Server at this office, and I'd rather not install and configure one. So, I have been considering using the provided SQL Server 2005 Express option that Veeam comes with. However, I have a question that I have yet to find either in the documentation or on this site.
1). Isn't SQL Server 2005 Express limited to a 4GB database maximum? And if so, how quickly am I going to reach this maximum backing up 5 VM's each consuming say 40GB of disk space?
2). How should I go about doing a backup of this B&R database in the event that a disaster happens to my Veeam B&R box?
--I found this thread: http://www.veeam.com/forums/viewtopic.p ... =15#p32932.
-- it suggests just running a command like this; SQLCMD -S GR-VEEAM\VEEAM -E -Q "BACKUP DATABASE VeeamBackup TO DISK='G:\backup\VeeamBackupdb_%All%.bak' WITH FORMAT"
-- I assume then, if disaster struck, I would reload the Veeam software on my box, then restore the above VeeamBackupdb.bak file and all of my configurations and backups would be available once again.
Thanks in advance.
1) 4GB is more than enough for any virtual environment. Veeam B&R doesn't store backup data inside its database, only configuration and session info. So this limitation is unlikely to ever be reached.
2) You found a good thread, the script mentioned should work for you. Generally speaking, it is ok to use any native tools to backup and then restore the database, you can use Management Studio instead of script, for example.
P.S. If you install B&R to a workstation box, please be aware that 4 cores CPU is recommended for better performance. However, less cores can also be ok, just don't forget to estimate CPU workload using Task Manager.
- SVP, Product Management
- Posts: 29891
- Liked: 5841 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland