[RESOLVED] SQL Backup

Hi

Can we take the Backup of SQL Database using VB as front-end .

Thanks

Thread moved to the 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

How do you want to back up the data, in to another database or output it to .sql file?

Hi

One option if possible is to copy MDF , LDF files with date extension . Secondly if possible output to .sql file.

Thanks

The second attachment here shows how to create a .sql backup script from a mysql database.

Hi

I am talking about Microsoft SQL Backup not MySQL of PHP

Thanks

Quote:

---

Originally Posted by Jagjit

Hi

I am talking about Microsoft SQL Backup not MySQL of PHP

Thanks

---

Ah ok! I remember someone else asking the same question a while back have you searched the forum?

Quote:

---

Originally Posted by Jagjit

Hi

One option if possible is to copy MDF , LDF files with date extension . Secondly if possible output to .sql file.

Thanks

---

You cannot copy those 2 files while the database is attached and live. SQL Server has it's own format to store both database and the log in 1 file (unless you want it in .sql file as an export).

Hi

Can u help me how it can be done

Thanks