Agusto Xaverius P Sipahutar

It's important to backup K2's databases before you deploy any new workflows.  At the moment there isn't a tool to remove K2 BlackPearl Workflow Process definitions deployed to a server.

 

I get this script from http://www.davehunter.co.uk/Blog/Lists/Categories/Category.aspx?Name=K2%20BlackPearl.

 

Here this script to backup database k2 blackpearl :

 

BACKUP DATABASE [Categories] TO DISK = N'D:\Backup_SQL\K2 DATABASE\Categories.bak' WITH NOFORMAT, NOINIT, NAME = N'Categories-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [Dependencies] TO DISK = N'D:\Backup_SQL\K2 DATABASE\Dependencies.bak' WITH NOFORMAT, NOINIT, NAME = N'Dependencies-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [EnvironmentSettings] TO DISK = N'D:\Backup_SQL\K2 DATABASE\EnvironmentSettings.bak' WITH NOFORMAT, NOINIT, NAME = N'EnvironmentSettings-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [EventBus] TO DISK = N'D:\Backup_SQL\K2 DATABASE\EventBus.bak' WITH NOFORMAT, NOINIT, NAME = N'EventBus-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [EventBusScheduler] TO DISK = N'D:\Backup_SQL\K2 DATABASE\EventBusScheduler.bak' WITH NOFORMAT, NOINIT, NAME = N'EventBusScheduler-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [HostServer] TO DISK = N'D:\Backup_SQL\K2 DATABASE\HostServer.bak' WITH NOFORMAT, NOINIT, NAME = N'HostServer-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [K2Server] TO DISK = N'D:\Backup_SQL\K2 DATABASE\K2Server.bak' WITH NOFORMAT, NOINIT, NAME = N'K2Server-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [K2ServerLog] TO DISK = N'D:\Backup_SQL\K2 DATABASE\K2ServerLog.bak' WITH NOFORMAT, NOINIT, NAME = N'K2ServerLog-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [K2SQLUM] TO DISK = N'D:\Backup_SQL\K2 DATABASE\K2SQLUM.bak' WITH NOFORMAT, NOINIT, NAME = N'K2SQLUM-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [SmartBox] TO DISK = N'D:\Backup_SQL\K2 DATABASE\SmartBox.bak' WITH NOFORMAT, NOINIT, NAME = N'SmartBox-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [SmartBroker] TO DISK = N'D:\Backup_SQL\K2 DATABASE\SmartBroker.bak' WITH NOFORMAT, NOINIT, NAME = N'SmartBroker-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [SmartFunctions] TO DISK = N'D:\Backup_SQL\K2 DATABASE\SmartFunctions.bak' WITH NOFORMAT, NOINIT, NAME = N'SmartFunctions-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [WebWorkflow] TO DISK = N'D:\Backup_SQL\K2 DATABASE\WebWorkflow.bak' WITH NOFORMAT, NOINIT, NAME = N'WebWorkflow-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [Workspace] TO DISK = N'D:\Backup_SQL\K2 DATABASE\Workspace.bak' WITH NOFORMAT, NOINIT, NAME = N'Workspace-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO