The Below SQL Command

------------

SELECT CONVERT (VARCHAR,GETDATE(),101) [Date]

Here GETDATE() is Date field of Table.

--

Out Put->mm/dd/yyyy

Restore Data With New Name

==============

RESTORE DATABASE Business_Data_TSQL

FROM DISK='d:\Business_Data.bak'

WITH

MOVE 'Business_Data' TO 'D:\TSQL\Business_Data.mdf',

MOVE 'Business_Data_log' TO 'D:\TSQL\Business_Data_log.ldf'