MSBI(SSIS,SSAS,SSRS,MDX) ,SQL Basics
Tuesday, November 19, 2013
MSSQL Table BackUp
MSSQL Server:
1-Table back up With table schema and Data:
Method 1:
select
*
into
[dbo]
.
[USER_backup]
from
[dbo]
.
[USER]
Method 2:
2-Table back up only Schema:
SELECT
TOP
0
*
INTO
[dbo]
.
[USER_Schema_backup]
FROM
[dbo]
.
[USER]
3-Data base Back Up:
4-Data base Differential Back Up:
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment