backup

[JIMMIE WHITAKER]

I'm using ms access 2000 .adp file, and tables on sql server / msde. On the
menu there's a backup option. It creates a file with a .Dat extension. How
do I take the Dat file and restore data? This news group has been real
helpful-- thanks.

[Simon Hayes]

"JIMMIE WHITAKER" <kp*****@worldnet.att.net> wrote in message news:<UX*******************@bgtnsc05-news.ops.worldnet.att.net>...

I'm using ms access 2000 .adp file, and tables on sql server / msde. On the
menu there's a backup option. It creates a file with a .Dat extension. How
do I take the Dat file and restore data? This news group has been real
helpful-- thanks.

It's not clear which menu in which application you're talking about -
is this Enterprise Manager, or some third-party tool? You can test if
it's a valid MSSQL backup like this (from Query Analyzer or osql.exe):

restore headeronly from disk = 'c:\temp\myfile.dat'

This should give you the details of the backup - if you get an error
instead, it's probably not an MSSQL backup.

In general, to backup and restore MSSQL databases, you use the BACKUP
and RESTORE commands, or you can create maintenance plans from
Enterprise Manager which will do this for you. If you're new to this,
I would suggest you spend some time reviewing the "Backing Up and
Restoring Databases" section in Books Online.

Simon

[JIMMIE WHITAKER]

I'm in ms access 2000, and backup is on a dropdown menu.
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:60**************************@posting.google.c om...

"JIMMIE WHITAKER" <kp*****@worldnet.att.net> wrote in message

news:<UX*******************@bgtnsc05-news.ops.worldnet.att.net>...

I'm using ms access 2000 .adp file, and tables on sql server / msde. On the menu there's a backup option. It creates a file with a .Dat extension. How do I take the Dat file and restore data? This news group has been real
helpful-- thanks.

It's not clear which menu in which application you're talking about -
is this Enterprise Manager, or some third-party tool? You can test if
it's a valid MSSQL backup like this (from Query Analyzer or osql.exe):

restore headeronly from disk = 'c:\temp\myfile.dat'

This should give you the details of the backup - if you get an error
instead, it's probably not an MSSQL backup.

In general, to backup and restore MSSQL databases, you use the BACKUP
and RESTORE commands, or you can create maintenance plans from
Enterprise Manager which will do this for you. If you're new to this,
I would suggest you spend some time reviewing the "Backing Up and
Restoring Databases" section in Books Online.

Simon

[Simon Hayes]

"JIMMIE WHITAKER" <kp*****@worldnet.att.net> wrote in message news:<hl********************@bgtnsc05-news.ops.worldnet.att.net>...

I'm in ms access 2000, and backup is on a dropdown menu.

<snip>

Well, I know nothing about Access, so I don't know if it's a generic
backup function, or if it's something specific in your Access
application. If it's a standard Access function, you might get more
help in an Access newsgroup.

Simon