asdb - what is it? Shold I back it up?

[mfine]

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.

My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.

Thanks,
Mark.

[Ed Murphy]

mf***@array.ca wrote:

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.

My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.

Google turns up nothing obviously relevant. Ask the customer to
show you 'asdb' - maybe it's the name of another SQL or Access DB,
or maybe they meant something else but botched the name.

[markfine]

Thaks.

Ed Murphy wrote:

mf***@array.ca wrote:

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.

My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.

Google turns up nothing obviously relevant. Ask the customer to
show you 'asdb' - maybe it's the name of another SQL or Access DB,
or maybe they meant something else but botched the name.

[rja.carnegie]

mf***@array.ca wrote:

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.

My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.

Is it perhaps "msdb"? "The msdb database is used by SQL Server, SQL
Server Enterprise Manager, and SQL Server Agent to store data,
including scheduling information and backup and restore history
information." (SQL Server 2000)

If that sounds like something you will make use of, then Books Online
has tips on backing it up. If that information isn't useful in your
disaster recovery plan, don't bother - you can use this database to
manage backups and automated maintenance, but you can do without it,
restore your customer's data onto a newly installed server.

We presume your customer's data is in a specially created database and
not in one of the built-in ones.

I suppose database creation date also is likely to reflect whether the
database was created during installation of SQL Server, or when you
started using it. But if the database was yours, then you'd know,
surely?

Is someone else keeping data on the same server?

[rcamarda]

I believe this is the database that Arcserve backup for windows uses.
Its a product by Computer Associates.
HTH
Rob
(open it up. if you see tables like asfilename, ashost, asjob,
asjobmap,
then this is what it is)

mf***@array.ca wrote:

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.

My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.

Thanks,
Mark.