Moving VeeamBackup.mdf (and ldf) to a different location

...oh, and restarting the Veeam services, obviously.

Hi @TurkTownBlue - what you should do for the Veeam supported way is:

• Open Veeam Cosnole on the VBR server
• Disable all your jobs
• Go to menu > Configuration Database and click ‘Backup Now’ to take a current backup of your configs
• Take note of the config backup location and copy it to the other server
• Install Veeam on the new server
• In the Console on the new server, open the menu > Configuration Database and select to Import > Migrate

Veeam doesn’t really have any info on solely moving the SQL DB and Log files. The DB config backup/restore is their only supported way….that I’m aware of.

The veeam connection is via the SQL instance. As long as the DB is attached in the new location then Veeam should be fine. You are making no other changes to the SQL instance.

OK, thanks guys. 

I figure if I only COPY the mdf/ldfs to the new location a re-attach, then even if it doesn’t like it I can always detach them and re-attach the originals.

I’m fairly happy with the DB Admin side - that’s my main role - Backup is a second hat that I wear.

The Veeam config is backup up daily and checked so, fingers crossed...

You can migrate the DB to another server or location.  Just follow this article - Migrating Configuration Database to Another SQL Server - User Guide for VMware vSphere (veeam.com)

If you install SQL on a larger drive just move the database over to there, attach it and then run the configuration utility for Veeam to redirect it.  😁

Ok, sounds good. Let us know how it goes. 

Thanks everyone. I’ll give it a try now that I’m back at work (tomorrow) and will post the results!

Sounds good and hopefully you are able to get things working.  Keep us posted.

Apologies for the delay everyone, family medical crisis prevented my even thinking about this until today.

As it transpired, it was pretty much as MarkBoothman and  dloseke suggested - with one or two complications:

1. Stop your running jobs on the Backup Server
2. Disable all the jobs noting which, if any, were already disabled
3. Stop the Veeam Services (use powershell, it’s easier)
4. Detach your Veeam databases in SSMS. If you Offline them first you will be unable to detach them.
5. Relocate the database mdf and ldf files to the new, roomier, location (this proved hugely problematic owing to permissions on the original files...which necessitated a sledgehammer approach involving enabling inheritance from the parent folder of the original mdfs)
6. Attach the new copies of the mdf/ldfs in SSMS
7. Restart the Veeam services (or just restart the Backup Server)
8. Re-enable the jobs you disabled at 2
9. Get a large beverage of you choice and try to relax

No worries at all. Appreciate the update & sharing what specifically worked for you. The last step sounds like the best one 😂