[RESOLVED] SQL Backup

[Jagjit]

Hi

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

Thanks

[si_the_geek]

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

[Nightwalker83]

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

[Jagjit]

Hi

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

Thanks

[Nightwalker83]

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

[Jagjit]

Hi

I am talking about Microsoft SQL Backup not MySQL of PHP

Thanks

[Nightwalker83]

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?

[Serge]

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).

[Jagjit]

Hi

Can u help me how it can be done

Thanks