Skip to content

Instantly share code, notes, and snippets.

@treffynnon

treffynnon/t-sql_dump.sql

Created February 4, 2010 15:18
Show Gist options
  • Save treffynnon/294721 to your computer and use it in GitHub Desktop.
Save treffynnon/294721 to your computer and use it in GitHub Desktop.
Download ZIP
T-SQL: Setup data dump
Raw
t-sql_dump.sql
sp_addumpdevice 'disk', 'pseudoName', 'C:yourFilename.mdb';
GO
DUMP DATABASE yourDatabaseName TO pseudoName;
GO
sp_dropdevice pseudoName;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment