DevShot - Database Snapshots for Developers

Tommi G

Rate me:

4.67/5 (3 votes)

25 Nov 20055 min read

48.2K

519

How to create runtime backups from SQL Server 2005 and restore them.

devshot.zip
- DevShot
  - DevShot WinApp
    - app.config
    - bin
      - Debug
        
        DevShot WinApp.exe.config
        
        DevShot WinApp.vshost.exe.config
        
        TestDatabase.mdf
        
        TestDatabase_log.ldf
      - Release
        
        DevShot WinApp.xml
    - DevShot WinApp.vbproj
    - DevShot WinApp.vbproj.user
    - frmMain.Designer.vb
    - frmMain.resx
    - frmMain.vb
    - My Project
      - Application.Designer.vb
      - Application.myapp
      - AssemblyInfo.vb
      - Resources.Designer.vb
      - Resources.resx
      - Settings.Designer.vb
      - Settings.settings
    - obj
      - Debug
        
        TempPE
      - DevShot WinApp.vbproj.FileList.txt
      - Release
        
        TempPE
    - TestDatabase.mdf
    - TestDatabase_log.LDF
    - TestDatabaseDataSet.Designer.vb
    - TestDatabaseDataSet.xsc
    - TestDatabaseDataSet.xsd
    - TestDatabaseDataSet.xss
  - DevShot.ndoc
  - DevShot.sln
  - DevShot
    - bin
      - Debug
      - Release
        
        DevShot.xml
    - DBAdapter.vb
    - DBAdapterCollection.vb
    - DevShot.vbproj
    - Framework.vb
    - My Project
      - Application.Designer.vb
      - Application.myapp
      - AssemblyInfo.vb
      - Resources.Designer.vb
      - Resources.resx
      - Settings.Designer.vb
      - Settings.settings
    - obj
      - Debug
        
        TempPE
      - DevShot.vbproj.FileList.txt
      - Release
        
        TempPE
  - doc
    - DevShot Documentation.chm
    - ndoc.log
  - MSSQL2005Adapter
    - bin
      - Debug
      - Release
        
        DevShot.xml
    - MSSQL2005Adapter.vb
    - MSSQL2005Adapter.vbproj
    - MSSQL2005Adapter.vbproj.user
    - My Project
      - Application.Designer.vb
      - Application.myapp
      - AssemblyInfo.vb
      - Resources.Designer.vb
      - Resources.resx
      - Settings.Designer.vb
      - Settings.settings
    - obj
      - Debug
        
        TempPE
      - MSSQL2005Adapter.vbproj.FileList.txt
      - Release
        
        TempPE

Imports System
Imports System.Reflection
Imports System.Runtime.InteropServices

' General Information about an assembly is controlled through the following 
' set of attributes. Change these attribute values to modify the information
' associated with an assembly.

' Review the values of the assembly attributes

<Assembly: AssemblyTitle("DevShot")> 
<Assembly: AssemblyDescription("")> 
<Assembly: AssemblyCompany("Netcoma")> 
<Assembly: AssemblyProduct("DevShot")> 
<Assembly: AssemblyCopyright("Copyright © Netcoma 2005")> 
<Assembly: AssemblyTrademark("")> 

<Assembly: ComVisible(False)>

'The following GUID is for the ID of the typelib if this project is exposed to COM
<Assembly: Guid("59875014-8390-407c-a5c0-d2d661d513fa")> 

' Version information for an assembly consists of the following four values:
'
'      Major Version
'      Minor Version 
'      Build Number
'      Revision
'
' You can specify all the values or you can default the Build and Revision Numbers 
' by using the '*' as shown below:
' <Assembly: AssemblyVersion("1.0.*")> 

<Assembly: AssemblyVersion("1.0.0.0")> 
<Assembly: AssemblyFileVersion("1.0.0.0")>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By

Tommi G

Web Developer CALM Oy

Finland

Microsoft Certified Professional (MCP)

DevShot - Database Snapshots for Developers

License

Comments and Discussions