Backup with SQL Engine

Hi all
I awant to backup the .MDF and .LDF files that are managed by a SQL
Server 7 Engine (the installation uses only the Engine not the full
SQL Server 7 installation).
How can I do that?
thanks!
Hi,
Use BACKUP DATABASE comamnd to backup the database. Refer SQL server books
online for
BACKUP database command.
Thanks
Hari
MCDBA
"steve simpson" <simpsonst3@.comcast.net> wrote in message
news:4107d689.1017269476@.msnews.microsoft.com...
> Hi all
> I awant to backup the .MDF and .LDF files that are managed by a SQL
> Server 7 Engine (the installation uses only the Engine not the full
> SQL Server 7 installation).
> How can I do that?
> thanks!
>
|||You can backup a database with the BACKUP command (see Books Online for the
syntax), and backup the resulting backup file to a backup medium, like tape.
If you don't have the graphical SQL Server client tools installed on your
server, you can use the osql command line tool to execute SQL statement.
More information about this you can also find in Books Online.
Jacco Schalkwijk
SQL Server MVP
"steve simpson" <simpsonst3@.comcast.net> wrote in message
news:4107d689.1017269476@.msnews.microsoft.com...
> Hi all
> I awant to backup the .MDF and .LDF files that are managed by a SQL
> Server 7 Engine (the installation uses only the Engine not the full
> SQL Server 7 installation).
> How can I do that?
> thanks!
>