...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...
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.
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.
This. If you stop your Veeam services and then stop your SQL database, detach and copy to your new location, and then attach in SQL and bring up the database using the same database name/instance, I don’t see any reason that Veeam won’t be able to reconnect to it when you restart the services. If the database was for some reason to change names, server names, etc, you should be able to use the database configuration utility to connect to the database, similar to how you would need to do if the server name changed (I’ve renamed a few Veeam servers in the past and had to repoint Veeam to the same database with a different server name after the server was renamed).
Thanks everyone. I’ll give it a try now that I’m back at work (tomorrow) and will post the results!
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:
- Stop your running jobs on the Backup Server
- Disable all the jobs noting which, if any, were already disabled
- Stop the Veeam Services (use powershell, it’s easier)
- Detach your Veeam databases in SSMS. If you Offline them first you will be unable to detach them.
- 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)
- Attach the new copies of the mdf/ldfs in SSMS
- Restart the Veeam services (or just restart the Backup Server)
- Re-enable the jobs you disabled at 2
- 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