Recover the function

Jayaprakash kannan

5y1.1k

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinitha T4y ago
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.
Amira Bedhiafi5y ago
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 Ansari5y ago
Hi,

You cannot recover once the function is deleted. As suggested by @Jignesh, you can recover from your backup file/database.
Jignesh Kumar5y ago
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/