query to check for duplicate rows

SELECT     columnName, COUNT(columnName) AS Expr1
FROM         tableName
GROUP BY columnName
HAVING      (COUNT(columnName) > 1)

restore sql server backup

Code to restore Sql Server from backup without overwriting the current database.

restore filelistonly
from disk = ‘d:\someLocation\oldDbName.bak’

restore database oldDbName from disk = ‘D:\someLocation\currentDb_db_200709190200.BAK’
with move ‘currentDb’ to ‘d:\Microsoft SQL Server\MSSQL\data\oldDbName_Data.MDF’,
move ‘currentDb_Log’ to ‘d:\Microsoft SQL Server\MSSQL\data\oldDbName_Log.LDF’