Recover the function

Question

I have Deleted the function. How to recover the function in SQL server

Amira Bedhiafi · Answer

You can achieve this in two different ways first : 1. With backup Right-click on the database and click Tasks>>Restore. Select the restoration source from under Source for restore. In the specified backup screen, add your database backup file and validate. Set the restoration destination under the Options tab and then validate 2. Without backup You can simply use a database recovery tool : List of Top 10 Best SQL Database Repair Tool of 2021 SysTools Stellar Kernel for SysinfoTools DataNumen DiskInternal Aryson Lepide

Rijwan Ansari · Answer

Hi, You cannot recover once the function is deleted. As suggested by @Jignesh, you can recover from your backup file/database.

Vinitha T · Answer

In SQL-Server, Deleted functions can be recovered if Database is backup. Steps: After connectinng to database, Right-click on it. Select Tasks -> Restore -> Database / Files and Filegroups / PagesSource Choose Database -> Then check your Database file -> click Ok Then choose your destination for restoration. If Database is not backup, recover by using SQL Database Recovery Tools.

Jignesh Kumar · Answer

Hi, If you have database backup then you can restore that database with other name and take function. For other few ways, Please refer this link, https://www.sqlserverlogexplorer.com/recover-deleted-functions-views-sql-server/

Recover the function

Answers (4)