Member Avatar for AngelicOne

I have a datagridview that is being populated by a dataset using an SQL table. How can I implement a backup and restore? Would I use the SQL select into statement?

  • 2 Contributors
  • 1 Reply
  • 48 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by darkagn
Member Avatar for darkagn

You can use the BACKUP statement to perform a backup of your database, and a RESTORE to perform a restore of a database. Here is a link to the documentation for MSSQL2008R2 versions of these functions. Post back if you need help deciphering the documentation.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.