Create K2ServerLog Database

Hi,

K2 has moved to a single database setup (also referred to as Consolidated Database) for K2 installations. There is no longer separate DBs for K2Server and Server Log. These functions have been broken up by schema inside the single database. 

As for performance, K2 has taken steps to ensure performance by how the file groups are organized. If you scrutinize the database configuration, you will see that the busier schema have there own dedicated files while lesser used schema are grouped together.

Over all, performance shouldn't be impacted and I'd suspect things should work better. Not to mention the benefits that are now available with regard to SQL Always On and overall DR planning through the use of a single database.

In short, one db is a good thing. 

S.

Hi Scott,

Thanks for your reply, I understand how it works.

Is there any way to clear de ServerLog database? I'm cleaning a development environment, I deleted previous workflow versions deleting also the log entries and in my reports doesn't appear any process, but if I look for serverlog database it's about 1'5 GB. I tried it using the archiving feature in the workspace but its reporting some errors and I'm not able to clean this database.

Thanks

Yes you're right. I'll try tomorrow.

Thanks again.