Groups | Blog | Home
all groups > sql server (alternate) > december 2006 >

sql server (alternate) : asdb - what is it? Shold I back it up?


mfine NO[at]SPAM array.ca
12/11/2006 6:47:42 AM
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.
markfine
12/11/2006 9:08:19 AM
Thaks.

[quoted text, click to view]
rja.carnegie NO[at]SPAM excite.com
12/11/2006 9:14:57 AM

[quoted text, click to view]

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
12/11/2006 12:10:57 PM
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)

[quoted text, click to view]
Ed Murphy
12/11/2006 4:41:11 PM
[quoted text, click to view]

Google turns up nothing obviously relevant. Ask the customer to
show you 'asdb' - maybe it's the name of another SQL or Access DB,
AddThis Social Bookmark Button