KACE Cloud MDM - Q3CY2018 Update-3 - Negative Search Filters

We are pleased to announce the September 2018 update to KACE Cloud Mobile Device Manager. In this release, we maintained a design that is familiar and easy-to-use while making our search more comprehensive and powerful. With KACE Cloud MDM, all data is connected, so you can search for any user or device using any attribute of related data. What's new is our negative search filters that allow you to search for users and devices that don't meet specific criteria or have a particular attribute.


How to Use Negative Search Filters

Let’s say you want to find all devices that don’t have a specific configuration installed, or all users whose devices haven’t checked in within the last week.

Using the Devices or Users filter in the left-hand panel, enter the search criteria that you want excluded from the search and click the minus button. The criteria will be added to the filter list at the top of the page, and your results will be updated. This feature is helpful when you need to check for device compliance and uniformity within your managed users and devices.

Be the first to comment

Best Way to Restore Database Backup in SQL Server 2012

Summary: The article illustrates the best way to view and restore a database backup in SQL Server 2012. We can do so by using a backup database and then restoring it when the database crashes or corrupts.


SQL Server is basically a database server from Microsoft. It supports a wide range of transaction processing, analytics applications and business intelligence in IT environments. SQL Server is featured with an option to create and restore the database from backup as per requirement. It will help users to prevent loss of data. The SQL Server keeps the backup of its database in a separate file i.e. .bak file. This backup file can be stored on a separate drive. But, you cannot view the backup file directly by opening it, you’ll have to restore it to view the database.

Some common reasons for SQL Database corruption

There are multiple reasons that can lead to SQL Database corruption as:

  • Accidental deletion.

  • Hardware failure.

  • Malfunctioning of software.

  • Human errors.

  • Virus attack.

  • Network failure.

Methods to View SQL Server .bak File

The SQL Server enables two different options to create and restore a database from the .bak file. Using these two different ways, you can restore SQL .bak file.

·         Using T-SQL.

·         Using SQL Server Management Studio.

You can use above methods to restore a .bak file in SQL Server. So, let’s discuss these two methods to restore database backup in SQL server 2012.

Restore database backup in SQL server 2012 using T-SQL :

To restore database backup in SQL Server 2012, you’ll have to first create a backup of all your database and then you’ll be able to restore it. If you have created a backup already, you can simply follow the below T-SQL script to restore database backup in SQL server 2012 from a .bak file.

RESTORE DATABASE AdventureWorks FROM DISK = 'E:\AdventureWorks.BAK'


Using the above T-SQL script, you can restore the database from the specified location and can create and restore it if it does not exist.

Restore database backup in SQL server 2012 Using Management Studio:

Go through the below steps to restore database backup in SQL server.

Step -1 Connect to the SQL server 2012.


Step - 2 Expand the tree structure of database. Now, right click on the database=> Tasks=> Restore=> Databases.


Step - 3 A restore database dialog box will appear.


Step -4 Now, select a database from the list for the destination database.


Step - 5 Select the source of the database.


Step 6 Specify the date and time of the database. For this, click on Timeline.


Step -7 Now, a new dialog box appears. You can choose the database for two options. One is the last backup taken and the second one, by specific date and time. Choose accordingly and click on "OK" Button.

  1. Click on the files to re-allocate them to folder.

Step - 8 Further, click on options. Here, you’ll see different options like restore options, tail-log backup, server connections and prompt. Click on the checkboxes accordingly.


Step - 9 Hit a click on OK button to restore the database backup.


Step -10 A message will appear indicating database restored successfully.


Method to restore the Database backup in SQL server 2012

I have explained all the manual methods to restore the database backup. Users can use the manual methods but they are quite lengthy and time-consuming. Also, for novice users, it is a tedious task to restore database backup manually. So, it is recommended to use a professional SQL backup recovery software. It is very efficient and reliable software tool. Using it, you can successfully restore MDF and NDF database files from SQL server backup.

Concluding words

In the above article, we have learned about the SQL server, methods to view and restore the database backup in SQL server 2012 using T-SQL script and Management Studio. Also, the automated methods have been discussed. Users can use any of the above methods as per their convenience. Hope it helps.




Be the first to comment

How to manage your imaging project with KACE this summer!

Several of you were not able to attend the inaugural meeting, so we are providing the link to the recording, as promised. Many thanks to Beth and Peter for their excellent presentation: “How to manage your imaging project with KACE this summer!” The detailed explanations of both the “how to’s” and the re-imaging results will be extremely valuable to many group members this summer and in the future. 

How to manage your imaging project with KACE this summer! -20180726 1702-1
Recording date: Thursday, July 26, 2018 1:02 pm
 Eastern Daylight Time (New York, GMT-04:00)
Panelist Information:  
Duration: 51 minutes

Re-imaging your systems with limited IT resources?  

Join our webcast where Beth Skrobanski and Peter Small from Albemarle County Public Schools will talk about how they are tackling this challenge with the KACE Systems Deployment Appliance (SDA).

They will share tips on how they are using the KACE SDA this summer to re-image up to 15,000 systems across 27 schools with a limited time window.

Learn how to use your KACE SDA to tailor your imaging needs to meet your SLA's in a timely manner without the drama!

Join us for a live webcast and discover how to:

• Streamline your Windows 10 migration
• Analyse your existing hardware and software
• Track your project and report on the status
• Migrate user data and configurations
• Save time and resources

Be the first to comment

PXE boot with error after update to version 6 of K2000

Estavamos utilizando a versão 5.1 do K2000 e subimos para a versão 6.0. Seguimos os passos de configuração, como por exemplo, alterar o 67 do DHCP de k2000.0 para undionly.kpxe.
Assim que o fizemos, não conseguimos mais fazer boot nos clientes. Já desabilitamos o DHCP da nossa rede e ativamos o DHCP do KACE, porém o erro continua o mesmo, ou seja, o problema não é o DHCP Windows.
Subimos um servidor novo do zero e o erro é o mesmo.

"We were using version 5.1 of K2000 and we went up to version 6.0. We follow the configuration steps, such as changing the DHCP 67 from k2000.0 to undionly.kpxe.
Once we did, we could not boot our customers any more. We have disabled the DHCP of our network and activated the DHCP of KACE, however the error remains the same, that is, the problem is not DHCP Windows.
We upload a new server from scratch and the error is the same."

Alguém pegou esse erro?
"Did someone get this error?"

Thank You!!
View comments (1)

Register now for KACE UserKon Europe!

Register now for KACE UserKon Europe 

November 13-14 at Les Jardin de Marais, Paris

KACE UserKon is the only conference specifically for KACE users. 

Find out more and register

Be the first to comment
Showing 1 - 5 of 3222 results