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]

Re: backup

"JIMMIE WHITAKER" <kpsklab@worldn et.att.net> wrote in message news:<UXgNc.139 258$OB3.8907@bg tnsc05-news.ops.worldn et.att.net>...[color=blue]
> 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.[/color]

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]

Re: backup

I'm in ms access 2000, and backup is on a dropdown menu.
"Simon Hayes" <sql@hayes.ch > wrote in message
news:60cd0137.0 407262346.7e355 2b2@posting.goo gle.com...[color=blue]
> "JIMMIE WHITAKER" <kpsklab@worldn et.att.net> wrote in message[/color]
news:<UXgNc.139 258$OB3.8907@bg tnsc05-news.ops.worldn et.att.net>...[color=blue][color=green]
> > I'm using ms access 2000 .adp file, and tables on sql server / msde. On[/color][/color]
the[color=blue][color=green]
> > menu there's a backup option. It creates a file with a .Dat extension.[/color][/color]
How[color=blue][color=green]
> > do I take the Dat file and restore data? This news group has been real
> > helpful-- thanks.[/color]
>
> 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[/color]

[Simon Hayes]

Re: backup

"JIMMIE WHITAKER" <kpsklab@worldn et.att.net> wrote in message news:<hlXNc.145 886$OB3.71566@b gtnsc05-news.ops.worldn et.att.net>...[color=blue]
> I'm in ms access 2000, and backup is on a dropdown menu.[/color]

<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