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