Posts Tagged 'SQL Server'

3 Easy Ways to Recover SQL Server Database Files

Database professionals play a huge role in different organizations, and they depend on database software to create and manage queries on a daily basis. One of the most widely used database softwares is SQL Server Management Studio. As a result of one of several causes, you could lose your SQL files. Below, we look at fast and easy ways to recover the data. Imagine working on a query on SSMS and all of a sudden there is a power outage. It gets worse, when you start SSMS later, you find that...

Read more »

How to Use the Copy Database Wizard in SQL Server

In this article, we look at the features of the copy database wizard for moving objects from one SQL instance to another. We further look at restrictions and tips to get past them. A SQL Server instance comprises of several objects, and if you ever you need to move those objects from the given instance to another then manually transferring them will not be a wise thing to do. For transferring your SQL objects from one instance to another you should make use of the Copy Database Wizard....

Read more »

What are Tail-Log Backups and When You May Need Them

In this article, we explain the concept of tail-log backups and check out the scenarios where they may be needed while using MS SQL Server Tail-Log Backups are used for capturing the log records for data, for which the user hasn’t created any back-ups to prevent the data from getting lost or deleted from the system and also to ensure that the log chain stays intact. It is recommended that the user backs-up his/her transaction log in its tail before starting a recovering program in his/her...

Read more »