LiteSpeed Restore from Remote Share v8.0

In versions of LiteSpeed for SQL Server prior to 8.0 I’ve always been able to restore backups from remote shares by cutting/pasting the remote share path (\\serverName\driveLetter$\backups).  In fact, the remote shares are not always actual shares.  If they were LiteSpeed would pick them up in the “browser”.  Often times they are just unshared paths but I’m able to access them using administrator rights.

After upgrading LiteSpeed to 8.0 I discovered that my remote paths will no longer be recognized as a valid path when I manually enter the paths.  The obvious work around is to copy the backup file(s) from the remote server to a local drive.  For small database backups this may be fine.  But for backup files that are hundreds of megabytes in size, the copy alone can take hours.

For DEV and UAT (user acceptance test, aka TEST) machines most of the restores will be coming from a production server.  Basically, once in a while our developers will want a refresh of the existing DEV/UAT databases from the production server.  This is where the issue of restoring from remote shares is the most common.

Instead of copying huge backup files from the remote servers I found it was much easier to change the default path of the local servers (DEV/UAT) backup path to point to the remote server’s backup directories.

Unfortunately, there is no interface in SSMS that will allow us to change the default backup path; it is a registry setting.  We have two ways to change the registry setting:

  1. RegEdit
  2. Extended procedure xp_regwrite

This post will describe how to use the extended stored procedures to change the default backup directory, and then use LiteSpeed to restore a DEV/UAT database from a remote production server.

I did find it necessary to use regedit  to determine the path of the BackupDirectory key.  It seems to be a little different for each instance, depending on the instance name.  The path will be something close to the following:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer

RegEdit

Copy the full path by right clicking on MSSQLServer ==> Copy Key Name.  You’ll need it for the call to the extended procedure to change the path value.

Paste the key from regedit into the following xp command to determine the current default backup directory:

DECLARE    @BackupDirectory VARCHAR(255)
EXEC master..xp_regread @rootkey=’HKEY_LOCAL_MACHINE’,
    @key=’SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer’,
    @value_name=’BackupDirectory’,
    @BackupDirectory=@BackupDirectory OUTPUT
SELECT @BackupDirectory

This will return the current default backup path.  To change the default backup path to the remote server’s backup directory:

EXEC master..xp_regwrite
     @rootkey=’HKEY_LOCAL_MACHINE’,
     @key=’SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer’,
     @value_name=’BackupDirectory’,
     @type=’REG_SZ’,
     @value=’\\myRemoteServer\j$\Backups’;

Now when you restore a database in LiteSpeed 8.0 the “Backup Directories” will expand to the directory structure on the remote server.  Just click through the directories as needed and select your backup files (FULL + DIFF for each stripe) and restore as usual.

LiteSpeedRestore

Note: This is only necessary if the backup directory is not explicitly shared.  Shared drives can be found by selecting the Browse Network.  It may take a little more effort to find the specific server, but the share will be presented.

Thanks to Greg Robidoux for his post Changing the default SQL Server backup folder.

If you do decide to make this change be sure to write LOCAL backups to the local backup drive.  By now your backups should already be configured in LiteSpeed, but this may be a point of confusion if a new person is introduced to your backup process.

Stay curious; keep learning…

0 Comments

Leave a Reply

You must be logged in to post a comment.

Using Gravatars in the comments - get your own and be recognized!

XHTML: These are some of the tags you can use: <a href=""> <b> <blockquote> <code> <em> <i> <strike> <strong>

popular blog editor sites uk best speech writer websites usa rhetorical analysis essay editor websites au professional phd dissertation hypothesis topics esl dissertation methodology writing website usa pay for anthropology blog post cheap dissertation chapter ghostwriter service online personal essay editor site gb critical writer service uk professional dissertation conclusion ghostwriters websites online write me trigonometry speech esl definition essay ghostwriters for hire usa the goldfish matisse write my environmental studies content custom problem solving writer services for phd the virtue theory popular rhetorical analysis essay editing for hire for college top mba article advice professional critical analysis essay editor site gb esl proofreading website uk type my music dissertation chapter top definition essay proofreading service for phd top scholarship essay on hillary top admission essay writers services for school pay to do composition essay best descriptive essay writers sites au custom custom essay editor websites uk top creative essay writers services gb cheap university essay writer service ca custom dissertation writer sites for mba help writing cheap phd essay on lincoln best essays editing service usa top creative writing ghostwriters sites uk cheap content ghostwriter services for masters custom bibliography ghostwriting service for phd pay for film studies course work cheap bibliography ghostwriting sites for university custom cover letter ghostwriting site for mba professional thesis statement writing sites for school top dissertation results writing for hire popular admission paper writers for hire for school esl essay ghostwriter site for masters persuasive essay ghostwriting service usa do my top university essay on hacking professional phd personal essay example custom business plan writer website uk top bibliography editor website for university professional course work proofreading services us professional research proposal proofreading sites for college popular dissertation methodology writer site us best article review proofreading for hire usa esl letter proofreading for hire online help writing persuasive essay on hillary pay for my best academic essay on lincoln custom college cv examples write me statistics bibliography cool hand luke symbolism best paper editing websites for university esl reflective essay writers for hire online critical writers service gb dissertation writers service uk analysis essay ghostwriting for hire gb cheap critical analysis essay editing websites usa order history dissertation methodology lysistrata shmoop best scholarship essay ghostwriters websites write algebra blog popular cv ghostwriting for hire for mba custom paper editing website for school cheap report writers for hire uk teenage suicide essay best personal statement writers sites uk help with my custom creative writing popular dissertation introduction ghostwriters services ca top thesis ghostwriters services ca esl thesis proposal editor site for university definition essay on happiness esl curriculum vitae ghostwriter sites for school custom critical essay ghostwriting website ca top paper writer service top dissertation abstract writer sites for mba professional analysis essay writers service for university popular biography ghostwriters services us top speech ghostwriter services for masters best problem solving ghostwriter services us buy admission essay on usa custom article ghostwriting site usa esl dissertation hypothesis ghostwriters service us cheap critical analysis essay proofreading website for masters help with health thesis statement help me write music course work top thesis ghostwriters service online best application letter writer websites for mba descriptive writer sites usa do my top critical analysis essay online esl school essay ghostwriters service for college presentation ghostwriters for hire ca help me write custom case study online best academic essay editor site for masters top research proposal editing service usa pay to get dissertation chapter online pay for my esl argumentative essay on donald trump adolf hitler essay is frankenstein the monster nursing essay editing websites a good argumentative essay professional presentation ghostwriting service gb popular expository essay editor for hire for school cheap homework ghostwriting websites for university law enforcement essay topics professional course work ghostwriters service for phd popular dissertation abstract writers websites for masters esl paper writer service us esl research paper writers sites gb popular dissertation chapter writers site us professional case study writing service for university write my custom personal essay on lincoln pay for finance curriculum vitae do my ancient civilizations essays best case study ghostwriting website for mba best school essay editing website ca popular movie review proofreading services for mba top annotated bibliography editor sites ca professional personal statement proofreading sites for university custom rhetorical analysis essay writers services for mba esl business plan writer service ca pay to write art & architecture literature review best papers ghostwriting services uk oppressed in spanish best case study ghostwriters sites professional dissertation chapter writer for hire for phd professional home work writer sites online professional personal statement writer websites help with popular creative essay on hillary clinton help with my geology admission paper professional dissertation editing services gb top college essay writing for hire esl personal essay writer websites us pay for astronomy cover letter popular phd essay ghostwriters services uk cheap mba thesis proposal advice top homework writing services gb popular biography proofreading for hire us professional dissertation hypothesis ghostwriter website for mba custom admission essay proofreading for hire for university order professional college essay esl dissertation chapter proofreading websites gb best essay on technology the road not taken analysis essay popular admission essay writer websites for masters best curriculum vitae ghostwriter website ca the role of women in the french revolution custom critical essay writing service for school top dissertation abstract ghostwriting websites ca essay advice online creative editing services usa popular thesis statement ghostwriting service for masters forgiving my father lucille clifton professional personal statement writing service for school top dissertation methodology writer websites uk popular literature review proofreading site usa custom university curriculum vitae ideas dissertation proposal writer services us essay describe a person best admission essay writers site for school best home work ghostwriter website best dissertation abstract ghostwriter for hire online cheap college dissertation abstract assistance top scholarship essay writer websites for school top content writing website for college top dissertation abstract editor website us custom phd masters essay assistance cheap article ghostwriter service for school esl definition essay editor services for school top analysis essay editor websites uk pay for my logic essays popular resume ghostwriters websites usa cheap descriptive essay writer website ca custom dissertation hypothesis writers for hire for phd professional application letter ghostwriting website usa top admission essay writer service au top expository essay proofreading services for mba cheap report proofreading sites gb write tourism curriculum vitae pay to do professional reflective essay on trump professional dissertation editing for hire gb cheap literature review proofreading services ca buy academic essay on donald trump esl bibliography writers site uk cheap resume ghostwriting service for phd mills harm principle thesis ghostwriting service benefits of cloning a modest proposal illustrations professional presentation writing website uk cheap dissertation methodology ghostwriters website uk custom thesis editor for hire for college top dissertation chapter writing sites au top personal essay editor site for masters custom mba papers examples cheap annotated bibliography writers websites for masters best annotated bibliography editor for hire ca help me write education creative writing best dissertation results ghostwriting websites gb cheap university essay writing service ca esl essay writer services for masters scholarship editing service gb custom dissertation hypothesis editor site for mba popular business plan editing websites gb popular essay editor sites for masters custom essays writer website us resume ghostwriting for hire uk type my film studies case study professional critical analysis essay on presidential elections best admission essay ghostwriting service au type my custom critical thinking online custom homework writers site for college best best essay editor website for college tourism essay ghostwriters website professional papers ghostwriters website uk esl college school essay topics best masters cover letter samples popular biography ghostwriting websites gb popular case study ghostwriting websites for masters custom best essay ghostwriter service for school best best essay editor for hire for college popular essay ghostwriter service uk popular dissertation proposal editing services popular resume ghostwriting sites for mba top article writers sites for phd help with my theater studies dissertation methodology professional phd college essay example write my cheap best essay online cheap book review ghostwriter sites for phd type my custom essay on trump top book review writing site custom personal essay proofreading websites usa popular dissertation methodology writing services admission paper editor for hire us best admission paper ghostwriter website for university cheap dissertation results ghostwriter sites gb professional problem solving ghostwriters sites ukstwriter-website-for-phd/'>top cheap essay ghostwriter website for phd write me best article review cheap thesis statement editing for hire usa cheap dissertation proposal ghostwriting services for mba best curriculum vitae ghostwriters site professional university personal essay samples popular course work writers websites for masters best dissertation hypothesis writers service uk custom thesis statement writers services gb music essay editing services best dissertation results writer site usa custom ghostwriting sites for college do my culture cover letter custom homework writing services gb write me top expository essay on founding fathers cheap cv proofreading service gb top research paper ghostwriters services usa help with statistics article review pay for custom university essay on shakespeare government writing service best case study ghostwriters services ca help me write government dissertation write my esl scholarship essay on hillary clinton professional letter ghostwriter for hire uk earth science ghostwriters service top bibliography proofreading sites for university professional custom essay ghostwriting website cheap dissertation proposal writing service ca critical essay ghostwriters services usa professional thesis writer services gb themes in robin hood cheap home work proofreading site write custom college essay on hacking cheap critical thinking writing websites au popular admission essay editor for hire for university professional analysis essay editing websites online professional university essay editor services gb custom movie review writer for hire online mark twain and realism popular argumentative essay editor websites au top dissertation results writing website for university custom papers ghostwriting sites for masters help me write esl descriptive essay on hillary esl definition essay writing websites gb esl critical essay writers websites popular thesis proposal ghostwriters site online do my math speech cheap masters essay editor websites for masters the necklace conflict esl letter ghostwriter websites esl persuasive essay writers for hire usa cheap blog post ghostwriting services usa order education thesis professional admission paper editing site online essays ghostwriter services ca professional blog editing service for masters custom best essay ghostwriter sites for phd thesis statement writers service online custom papers writer websites us problem solving proofreading for hire us top cover letter writer service for mba best dissertation methodology ghostwriters website au pay to get science dissertation methodology cheap cover letter editing website for masters top reflective essay proofreading websites for phd cheap essays editor service for mba esl school scholarship essay assistance top dissertation results ghostwriter service for phd type my critical analysis essay on presidential elections cheap cv proofreading sites uk cheap application letter editor site au pay to do political science application letter thesis ghostwriters site usa ideas for cv cheap resume ghostwriters for hire ca best dissertation writers service for school cheap content proofreading service for phd esl article review writing for hire us essay on sportsmanship custom mba essay editor service online popular case study proofreading for hire for college professional course work ghostwriters for hire us cheap content writing sites online write popular movie review custom cheap essay editing site for university help writing cheap rhetorical analysis essay on donald trump custom letter ghostwriter for hire for mba cheap school phd essay samples types of deterrence help writing popular blog post online best cover letter editing services for college esl personal essay writing for hire for university popular college scholarship essay topic custom literature review proofreading site for college best essays ghostwriters websites usa top proofreading site usa cheap course work proofreading websites online esl essays editing site ca professional thesis statement ghostwriter websites popular critical thinking ghostwriter service for masters buy professional university essay on lincoln pay for political science bibliography best college admission paper pay to do cheap rhetorical analysis essay on presidential elections esl article review editor service ca dissertation introduction ghostwriting websites au write my mathematics dissertation abstract top admission paper writers site usa nursing ghostwriter website top writing for hire for university decomposition of copper carbonate help me write top admission essay on hillary type my geology dissertation chapter best course work writer service for college personal essay ghostwriters for hire online professional college essay writers service for mba film bodies gender genre and excess best definition essay writing website for mba popular blog post editor websites gb cheap scholarship essay writer sites for masters how boats work popular college movie review ideas write me esl argumentative essay on usa cheap scholarship essay editor website for phd esl personal statement proofreading for hire for university popular essay ghostwriter website gb popular curriculum vitae writers service for mba popular dissertation methodology writer site for mba help with best dissertation abstract best resume writer service gb esl homework editing website au cheap definition essay writer service for phd esl home work ghostwriter site for university help with my top school essay on civil war popular paper ghostwriting service ca custom dissertation results writers sites gb critical ghostwriter services usa custom dissertation results writer services usa my life philosophy pay for custom expository essay on usa cheap dissertation chapter ghostwriter services for college professional dissertation results ghostwriting site for mba pay to do poetry homework top critical thinking ghostwriting services gb professional curriculum vitae editing websites ca creative writing service usa professional scholarship essay ghostwriter websites usa esl dissertation conclusion proofreading site us essays on war professional homework proofreading service online best cover letter writers sites for college custom cheap essay proofreading site for masters cheap bibliography editing sites usa popular best essay writer site us best blog ghostwriter website ca dissertation proposal ghostwriter services us professional cv ghostwriting websites uk esl personal essay ghostwriters service au cheap curriculum vitae proofreading website for college professional dissertation editing sites gb professional dissertation introduction ghostwriters service for phd best best essay editing service for college freedom in america essay custom dissertation conclusion writing website for mba cheap blog editing site online custom writers website us best problem solving writing website uk custom academic essay writer websites ca cheap application letter writers sites for mba professional phd essay editor website help with sociology dissertation chapter top admission paper proofreading websites uk popular personal essay ghostwriting for hire au best phd dissertation topic pay to write investments literature review dare program essays professional biography ghostwriters website for university professional assignment editor sites for masters cheap paper editing websites for university top reflective essay writer service uk best critical analysis essay editing services for university best research proposal ghostwriting site for school essay writing site uk custom scholarship essay ghostwriter for hire for university ed masry law firm custom thesis statement ghostwriters site us custom admission essay writers services gb esl cheap essay editor service esl blog proofreading for hire gb custom bibliography writer service usa dissertation conclusion editing sites online custom letter writing sites for mba best argumentative essay ghostwriting service popular masters essay ghostwriting services analysis ghostwriter sites usa top book review ghostwriters websites for college esl argumentative essay writing for hire usa best cheap essay ghostwriter sites custom masters dissertation topics pay to do best cheap essay on pokemon go top movie review ghostwriting site uk best descriptive essay writing sites for phd custom resume writing sites for university esl rhetorical analysis essay ghostwriting sites for mba thesis proposal editing site online custom dissertation chapter ghostwriting site gb popular phd essay proofreading website usa cheap literature review editor site online cheap university essay editing for hire au persuasive essay proofreading website ca buy government cv james cone books esl application letter editing sites for phd custom case study ghostwriter website online custom school essay ghostwriter site au curriculum vitae ghostwriter site us custom persuasive essay editing website for university samples for masters essay the 60s miniseries custom paper ghostwriters websites gb best dissertation hypothesis ghostwriters websites us professional dissertation conclusion writers website esl home work writers for hire for mba cheap article review writing websites uk popular academic essay ghostwriting for hire ca top essay writing services for college college ghostwriter for hire uk dissertation introduction writer site usa popular best essay editor service write me best dissertation conclusion custom report writers services usa buy professional critical analysis essay on civil war top admission paper editor site uk custom phd essay writer services for phd esl best essay writing site for school custom university essay proofreading services usa write shakespeare studies cover letter professional thesis ghostwriter for hire ca pay for my education speech top thesis statement ghostwriter services for university pay for custom college essay on hillary esl cover letter proofreading websites for university best phd dissertation introduction examples popular essays writers websites for masters best expository essay editing services us course work editing sites top definition essay editor sites cheap blog post editor sites uk scholarship essay on civil war top term paper ghostwriting services for masters help writing english home work custom mba letter help cheap research proposal writers sites for school cheap definition essay editing websites ca best term paper writers site for college