move app-v 4.5 database

[xing]

Does anyone have a procedure to move the app-v 4.5 database to a different sql server. I found a article from microsoft http://support.microsoft.com/default.as ... -US;932136 but this article is for a older version.

[olekristian]

Hi xing.

Try this:
http://support.microsoft.com/default.as ... -US;932136

[xing]

This article is for a older version. This doesn't apply for 4.5

[olekristian]

My bad, was the same article.

[xing]

The version is 4.5 sp1

Microsoft System Center Application Virtualization Management Server Version 4.5.2.17140 (4620)

[jur]

I think the article mentioned still covers the information you need.
Check the SQL database permissions carefully.

[xing]

Finally I think I got it.

- change the registry to point to the new database
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SoftGrid\4.5\Server\SQLServerName
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SoftGrid\4.5\Server\SQLDatabaseName

- change \Microsoft System Center App Virt Management Server\App Virt Management Service\SftMgmt.udl
iisreset to apply

- change the following tables via sql
dbo_DATA_SOURCES
dbo_ROLE_ASSIGMENT
dbo_SERVER_GROUPS
dbo_SERVERS

not all tables need to be edited. I also changed the servername so I had to edit some more settings. Just look into these tables and edit what you need.

Off course the permissions in SQL need to be adjusted so the service can start. If the service doesn't start look in the eventviewer to see which permissions still aren't correct.

Of course use kb932136 for the other changes.

[xing]

I'm still not there. After I moved the database and changed the setting so I can start the management console. I do see all applications and I can add new applications. But when I try to change a existing application I get an erro 0000B004.

When you lookup this error Microsoft states that the transaction log of the sql database is full. This isn't the case. So I can add applications and change them, but I can't do this for existing applications.

Does anyone have a clue?

[jur]

Is the recovery model on the new database the same as the previous one?

[xing]

Yes it is. I tried to change these settings and also created a new log file. But the error stays.

[gimli]

This is what Microsoft has to say about it, i suppose you tried these already?

http://support.microsoft.com/?kbid=930424

[xing]

Yes I did. The strange thing is that I can change some sections. All existings apps I can't change

[jur]

Not sure where it helps but:
Could you tell us which between which SQL Server version(s) you are moving and maybe which OS-es(voor SQL, VAS etc.) you're using?

Do you know how to use the SQL Server Profiler tot trace DB activity? Maybe it throws an error where you can work with.

[gimli]

Yes I did. The strange thing is that I can change some sections. All existings apps I can't change

Try Jurjens suggestion to see what it comes up with. It's definately strange behaviour.

Do you still have the "old" environment? it could be that in the former configuration the log was full, and for some reason it still think's it is (although this is very rare)

[xing]

The old environment still works fine. I'm trying to make a procedure for moving the database. The os en sql versions are the same.


With sql profiler I don't see anything strange, but I'm not that good with sql. In the trace I get the following:

Existing application:

exec sp_executesql N'UPDATE Applications SET
name=@P1,enabled=@P2,package_file=@P3,osd_file=@P4,version=@P5,icon_file=@P6,lic_group_id=@P7,server_group_id=@P8,description=@P9,app_group_id=@P10,package_id=@P11
WHERE (app_id=@P12)',N'@P1 nvarchar(64),@P2 bit,@P3 nvarchar(512),@P4 nvarchar(512),@P5 nvarchar(16),@P6
nvarchar(512),@P7 int,@P8 int,@P9 nvarchar(512),@P10 int,@P11 int,@P12 int',N'CitaVista
2009',1,NULL,N'\\vm-lt00857\CONTENT\W0503.100\CitaVista 2009
4.4.0.0.osd',N'4.4.0.01',N'\\vm-lt00857\CONTENT\W0503.100\CitaVista_2009_NED_W0503 Icons\CitaVista 2009
4.4.0.0.ico',NULL,2,N'',491,489,1262

New (copy) application:

exec sp_executesql N'UPDATE Applications SET
name=@P1,enabled=@P2,package_file=@P3,osd_file=@P4,version=@P5,icon_file=@P6,lic_group_id=@P7,server_group_id=@P8,description=@P9,app_group_id=@P10,package_id=@P11
WHERE (app_id=@P12)',N'@P1 nvarchar(64),@P2 bit,@P3 nvarchar(512),@P4 nvarchar(512),@P5 nvarchar(16),@P6
nvarchar(512),@P7 int,@P8 int,@P9 nvarchar(512),@P10 int,@P11 int,@P12
int',N'test',1,NULL,N'\\Vm-lt00857\CONTENT\W0503.100\CitaVista 2009
4.4.0.0.osd',N'2',N'\\Vm-lt00857\CONTENT\W0503.100\CitaVista_2009_NED_W0503 Icons\CitaVista 2009
4.4.0.0.ico',NULL,2,N'test1',338,302,1278

So the change get applied with the new application and I get an error with the existing application.