CODEWITHSUNDEEP
sql-server-2008database-backups
Dc Redwing
Dc Redwing

Reputation: 1791

SQL Server 2008 : how to back up database by query

I was studying SQL Server and I got a question about about creating queries for backing up database.

I knew that SQL Server 2008 has function to create a .bak file.

However, I am not sure if I can generate the queries for whole database.

In SQL Server 2008, do they have function to generate the queries for backing up whole database ?

thanks

Upvotes: 0

Views: 2268

Answers (1)

Daniel Powell
Daniel Powell

Reputation: 8283

You can generate the script yourself just setup a backup like normal but instead of clicking the normal button to start in the top left corner there is a script option enter image description here

See the backup command for more advanced options

Upvotes: 2

Related Questions