Posted by rja.carnegie on 12/11/06 17:14

mfine@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?

[Back to original message]