Nothing loose by learning again. Definitely gain If you just don't let it go away. - Bvsc.
Friday, November 23, 2012
Table Backup with native SQL, Process 3
-- Table Backup with native SQL, Process 3
Version : SQL 2008 or later.
Table Backup.
You can get the result in 4 types...
Process 1 : Generating scripts
Process 2 : Import/Export Option (T-SQL/SSIS)
Process 3 : Inserting into new table (Select * into newtab from baktab)
Process 4 : Inserting into existing table (Create newtable with same structure as
Original table, Insert into newtable select * from backtab)
Here we can see Process 3 : Please click here for Process1 or Process2
You can do this same job by using a simple T-SQL line.
SELECT * INTO OriginalTable_Bak FROM OriginalTable
Note: By using this process you can backup the table data. You cant get keys, references and indexes directly.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment