If the job completes successfully, I assume it's ok. Verify the backup file is there. It's good to practice restoring once in a while.

Either way, right click on the Database -> Tasks -> Generate Scripts

This might help you avoid future problems:

-- Databases NOT Backed Up Since YYYY-MM-DD

select * from master..sysdatabases db

where (not exists

(select * from msdb.dbo.backupset

where db.name = msdb.dbo.backupset.database_name

and backup_start_date >...

Using dbo specifies the schema. But since dbo is the default, you don't really need to specify it unless you have stored procedures with the same name under a different...

Why is the log file so big ? Are you doing regular transaction log backups ?

Krishna -878600 (11/3/2009)

You can use Backup-Restore method which is the easier one for not...

Here's a rough draft starting point for you:

select bset.database_name, bset.Type, convert(varchar(25),backup_start_date,101),convert(varchar(25),getdate()-1,101) , media.physical_device_name

,bset.*

from msdb.dbo.backupset bset

join msdb.dbo.backupmediafamily as media on bset.media_set_id = media.media_set_id

where database_name = 'MyDatabase' and

type...

It might be better to ask in the 2008 Administration forum, where you're sure to find people with 2008 experience, then update this thread with a link to the new...

As discussed in the similar thread a few days ago, there may be a better solution. Discussing WHY you want to kill the spid, may lead to new ideas.

Are you sure you cannot keep going with SP4 ? If you give more details about your problem, maybe some of the experts here (not me) will have advice...

Under what conditions would you need to uninstall a service pack ? I haven't experienced problems, but it seems they do exist. This is the 2nd post in the...

Testing by doing an actual restore, including transaction logs, will be more beneficial because it will make sure you know the actual steps .... you'll be more prepared in case...

There's probably a better way, but this should work:

select count(*)

frommaster.sys.databasesas DB

inner joinmaster.sys.master_filesas MF on MF.database_id = DB.database_id

where DB.name = 'Express_DB'

and MF.name = 'Express_Data'

and (MF. /131072.) >3.5

if @@rowcount > 0

EXEC...

This is an 18 month old thread. Not sure that necro-posting has much value in most cases.

Wasted my time reading it until I noticed.

Mish-Mash of Campy 10. That's my homemade Franken-bike