Disabling wireless backup is very handy for migrating users from one BES domain to another, just make sure to turn it back on once they have restored their data. As stated earlier in the thread it will prevent the items being wirelessly synced from being restored from a local (USB) backup.
I use something like this to disable wireless backup:
Quote:
UPDATE BESMgmt.dbo.SyncConfig
SET ServerEnabled = N'0'
FROM BESMgmt.dbo.UserConfig AS u
INNER JOIN BESMgmt.dbo.SyncConfig AS s ON u.Id = s.UserConfigId
inner join BESMgmt.dbo.SyncDataSource AS d ON s.SyncDataSourceId = d.Id
inner join BESMgmt.dbo.SyncDbType AS t on s.SyncDbTypeId = t.Id
WHERE u.mailboxSMTPAddr = 'user@domain.com' and d.name = 'backup' and t.name = '*'
GO
|
import it into SQL using the sqlcmd tool like this:
sqlcmd -S <SQLServer> -W -s ; -i DisableWirelessBackup.sql
and something like this to enable it again:
Quote:
UPDATE BESMgmt.dbo.SyncConfig
SET ServerEnabled = N'1'
FROM BESMgmt.dbo.UserConfig AS u
INNER JOIN BESMgmt.dbo.SyncConfig AS s ON u.Id = s.UserConfigId
inner join BESMgmt.dbo.SyncDataSource AS d ON s.SyncDataSourceId = d.Id
inner join BESMgmt.dbo.SyncDbType AS t on s.SyncDbTypeId = t.Id
WHERE u.mailboxSMTPAddr = 'user@domain.com' and d.name = 'backup' and t.name = '*'
GO
|
and you can use a query like this to get any users who have wireless backup disabled, I use this one as a source to turn wireless backup on..
Quote:
SELECT mailboxSMTPAddr
FROM BESMgmt.dbo.UserConfig AS u
INNER JOIN BESMgmt.dbo.SyncConfig AS s ON u.Id = s.UserConfigId
inner join BESMgmt.dbo.SyncDataSource AS d ON s.SyncDataSourceId = d.Id
inner join BESMgmt.dbo.SyncDbType AS t on s.SyncDbTypeId = t.Id
WHERE ServerEnabled = '0' and d.name = 'backup' and t.name = '*'
GO
|
call it with sqlcmd like so:
sqlcmd -S <SQLServer> -W -s ; -i getDisabled.sql -o getDisabled.txt