I assume you have it on another filegroup other than the primary.

This is quite a pain, but you can create a new filegroup, add one data file to it....

Check and review the dts packages, jobs. There might be a tsql program that went out of hand. If this happens on particular hours of the day, fire up your...

select name, databasepropertyex(name, 'recovery') from master..sysdatabases

😀

Time to put one in place now. Maintenance plan comes in handy. Just backup "all databases", or "all system" and "all user" databases. In most cases, you also don't need...

There's no option to skip writing to msdb backuphistory in the backup database command, so I'm afraid you can't get away with it. So, you'll have to go with what...

Yes, you have to exclude .mdf and .ldf files in TSM. You can't back them up while the database is online. What you need to do is schedule a disk...

I wonder if the order these tasks show up in maintenance plan wizard has something to do with it (optimization>integrity check>backups). You do not want to keep a backup with...

Nothing in event viewer as well?

Use import/export wizard in sql server enterprise manager, use text file (csv) as your destination format, then use a query to specify and filter the data you would like transferred.

yes, it is detach/attach that is your quickest approach..sql7 has it.

Tried adding trace flag 3608?

Was the user you used to connect to sql server in your connection string in vb has proper permissions? Did you use trusted connection or integrated security?

The easiest way would be to set up an sql server event alert. There's an alert definition for db log file being full.

create your temporary table..

INSERT #yourtemptable exec('restore filelistonly from disk=''....xl.bak''')

You can also check the db datecreated if it's recent, you'll have an idea when the database just got restored.