SQL Server Restore Filelistonly from disk
Many a times we need to get the details of what is in the database backup device before we do a database restore for e.g. if we have to move the …
SQL Server Restore Filelistonly from disk Read MoreSQL Server Accidental DBA Series
SQL Server Accidental/Involuntary/Junior DBAs Series
SQL Server restore master database
Restore master database is a must know task for any DBA. Master database is one of the key SQL Server database and should be a part of backup/maintenance plan. In case …
SQL Server restore master database Read MoreSQL Server restore database with move example
A common task for a DBA is to restore a database to a new location. The script for the same is given below USE [master] GO RESTORE DATABASE [AdventureWorks] FROM DISK …
SQL Server restore database with move example Read MoreRestore SQL Server database from bak file command line
Here is a script to restore SQL Server database from bak file command line. This is done via SQLCMD through command line. The first thing is to open up the command …
Restore SQL Server database from bak file command line Read MoreFunction to Convert Text String to Proper Case in SQL Server
Many a times need arises to convert a string into proper case specially the names. Let’s have a look at a SQL Server function to convert text string to proper case. …
Function to Convert Text String to Proper Case in SQL Server Read MoreFunction to Convert String to Date in SQL Server
The SQL Server has inbuilt function to convert string to date. It can be done using CAST/CONVERT as shown below DECLARE @stringdate varchar(100), @cast_dt datetime, @conver_dt datetime SET @stringdate=’09/25/2014′ SET @cast_dt=CAST(@stringdate …
Function to Convert String to Date in SQL Server Read MoreRestore database backup to different name in SQL Server
A common day to day task for a DBA is to backup/restore databases for testing/development/production purposes. In this blog we’ll see how to restore database backup to different name. Let’s first …
Restore database backup to different name in SQL Server Read MoreSQL Server Find largest tables
Here is a query to SQL Server find largest tables in a database. It’s very important for a DBA to monitor table size over time to foresee storage requirement/performance issues. The …
SQL Server Find largest tables Read MoreSQL Server shrinking transaction log file
Every now and then there is a question on forum mentioning that transaction log file has grown large, how to shrink it. This blog talks about SQL Server shrinking transaction log …
SQL Server shrinking transaction log file Read MoreHow to kill multiple sessions in SQL Server
In my last blog I talked about how to kill a session in SQL Server. In this blog I will talk about how to kill multiple sessions in SQL Server. The …
How to kill multiple sessions in SQL Server Read More