This error is due to the non-existing file path for .mdf and .ldf files while restoring the database using .bak file.

Solution:

1) While restoring database using .bak file, Go to Files...

Hi, here is the sample code...

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

if exists (select * from sysobjects where id = object_id('dbo.getStaffNamesForPersonalReferences') and sysstat & 0xf = 0)

drop function dbo.getStaffNamesForPersonalReferences

GO

CREATE FUNCTION dbo.getStaffNamesForPersonalReferences(@PERSONAL_REFERENCES varchar(2000))

RETURNS...