Hyperbac to the rescue, again....syslnklgns

Another great feature of Hyperbac ver. 4.1.73.0.

I specify the version because they were aquired by Reg-gate who, seeminly severed this functionality and has relabeled, enhanced :-|, this former built in feature as SQL virtual restore.

EXEC master..sp_addlinkedserver

@server = 'masterbk',

@srvproduct = '',

@provider = 'HyperBac.oledbmtf',

@datasrc = 'C:\master_20110105_FULL.hbc,1'

SELECT * FROM masterbk..sys.syslnklgns

...

srvid	lgnid	name	status	modate	pwdhash
1	0	srvTreasureLnk	0	2007-12-01 11:00:03.000	0x01000000BOBSMAGICKEYOFHAPPYNESS11011001TESTACULARTOOLSTYHYPERBAC000

Now I can re-create the linked server object without needing to know the forgotten magic word.

~Enjoy