Tuesday, February 14, 2012

backup

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."JIMMIE WHITAKER" <kpsklab@.worldnet.att.net> wrote in message news:<UXgNc.139258$OB3.8907@.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|||I'm in ms access 2000, and backup is on a dropdown menu.
"Simon Hayes" <sql@.hayes.ch> wrote in message
news:60cd0137.0407262346.7e3552b2@.posting.google.c om...
> "JIMMIE WHITAKER" <kpsklab@.worldnet.att.net> wrote in message
news:<UXgNc.139258$OB3.8907@.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" <kpsklab@.worldnet.att.net> wrote in message news:<hlXNc.145886$OB3.71566@.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

No comments:

Post a Comment