-
- Novice
- Posts: 3
- Liked: never
- Joined: Jul 23, 2020 1:52 am
- Full Name: billcao
- Contact:
can't migrate database
Case #04299622
Hi ,
This is my first post, so please let me know if anything is inappropriate!
I'm testing veeam with community version , and when I want to migrate database from SQL express to standard version to solve 10G limit problem(sql express) ,but when I run "Configuration Database Connection Settings" issue happened , it always alert "Unable analyze processes. Access is denied ", I use Windows authentication . can you tell me how to troubleshooting ?
looking forward to your reply .. thanks!
Hi ,
This is my first post, so please let me know if anything is inappropriate!
I'm testing veeam with community version , and when I want to migrate database from SQL express to standard version to solve 10G limit problem(sql express) ,but when I run "Configuration Database Connection Settings" issue happened , it always alert "Unable analyze processes. Access is denied ", I use Windows authentication . can you tell me how to troubleshooting ?
looking forward to your reply .. thanks!
-
- Product Manager
- Posts: 14839
- Liked: 3085 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: can't migrate database
Hello,
and welcome to the forums.
I assume that you follow www.veeam.com/kb1889 - that means it's a SQL configuration issue. I suggest to troubleshoot with SQL commands or SQL management studio instead of Veeam.
Just because I'm curious: what are you doing, that you hit the 10GB limit with community edition? Around 500 VMs should be okay with 10GB... which is far beyond community edition.
Best regards,
Hannes
and welcome to the forums.
I assume that you follow www.veeam.com/kb1889 - that means it's a SQL configuration issue. I suggest to troubleshoot with SQL commands or SQL management studio instead of Veeam.
Just because I'm curious: what are you doing, that you hit the 10GB limit with community edition? Around 500 VMs should be okay with 10GB... which is far beyond community edition.
Best regards,
Hannes
-
- Novice
- Posts: 3
- Liked: never
- Joined: Jul 23, 2020 1:52 am
- Full Name: billcao
- Contact:
Re: can't migrate database
Hi Hannes ,
thanks for your reply .
I just do 1 job is backup files to tape (data size nearly 10T ), and gathered this log from system events :
" Could not allocate space for object 'dbo.Backup.Model.JobSessions'.'PK_Backup.Model.JobSessions_id' in database 'VeeamBackup2' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. "
" CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database."
"File to Tape Backup job 'File to Tape Job 1' finished with Failed.
Job details: Cannot enumerate 17 folders
Processing 01.XXXX.local
Job has been terminated Error: Failed to save files info to the configuration database
Error: Failed to save files info to the configuration database"
thanks for your reply .
I just do 1 job is backup files to tape (data size nearly 10T ), and gathered this log from system events :
" Could not allocate space for object 'dbo.Backup.Model.JobSessions'.'PK_Backup.Model.JobSessions_id' in database 'VeeamBackup2' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. "
" CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database."
"File to Tape Backup job 'File to Tape Job 1' finished with Failed.
Job details: Cannot enumerate 17 folders
Processing 01.XXXX.local
Job has been terminated Error: Failed to save files info to the configuration database
Error: Failed to save files info to the configuration database"
-
- Product Manager
- Posts: 14839
- Liked: 3085 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: can't migrate database
I guessed something like that... yeah, the software is not built for that type of usage (see forum search)
-
- Novice
- Posts: 3
- Liked: never
- Joined: Jul 23, 2020 1:52 am
- Full Name: billcao
- Contact:
Re: can't migrate database
YES! But we do have a need for it now .. Do you have Any suggestions? many thanks!
-
- Product Manager
- Posts: 14839
- Liked: 3085 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: can't migrate database
I only have the suggestions I made above. For community edition, chances are low that support will help troubleshooting the SQL connection.
Who is online
Users browsing this forum: Bing [Bot], iDeNt_5, NickyP101, veremin and 300 guests