Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server event alert - restore from UNC path. Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 5:20 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:23 AM
Points: 24, Visits: 195
Hi,

I have a SQL Server event alert that fires after a database restore using error ID 18267. This works fine when using a local path, but not if a UNC path is specified in the script. Has anybody out there come across this before? I need to track restore activity and fire a SQL Agent job after each successful restore.

I've trawled [url=http://technet.microsoft.com/en-us/library/cc645603(v=sql.105).aspx][/url] and the only error ids I can see related to successful restore are:

4356 - Restore is complete on database '%ls'. The database is now available.

18267 - Database was restored: Database: %s, creation date(time): %s(%s), first LSN: %s, last LSN: %s, number of dump devices: %d, device information: (%s). Informational message. No user action required.

18268 - Log was restored. Database: %s, creation date(time): %s(%s), first LSN: %s, last LSN: %s, number of dump devices: %d, device information: (%s). This is an informational message. No user action is required.

18269 - Database file was restored. Database: %s, creation date(time): %s(%s), file list: (%s), number of dump devices: %d, device information: (%s). This is an informational message. No user action is required.

None of these fire when restoring from UNC path.

Thanks,

Chris
Post #1498261
Posted Wednesday, September 25, 2013 6:18 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:23 AM
Points: 24, Visits: 195
Update: It appears that something has broken my alerts. Drop and create them and all works fine...
Post #1498287
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse