CODEWITHSUNDEEP
sqlsql-serversql-server-2008backup
Stefan Edwards
Stefan Edwards

Reputation: 87

How to take table backup in SQL Server Express

I have one SQL Server database table. I need to take backup of my table daily based on the date. For that I need to write a script. But I'm new to SQL Server can any one please help me.

Thanks in advance

Upvotes: 0

Views: 5729

Answers (1)

user1703059
user1703059

Reputation: 94

You could copy it with command 

select * into new_table1 from primarytable

This will create a table named new_table1 with data from primarytable.

You must of course backup the whole database.

Upvotes: 2

Related Questions