Good question Steve.

The way I understand it, you are trying to move data from production to dev to test etc?

Is that accurate?

Evil Kraig F (6/27/2012)

---

If you can, try to test each package independently to find out which particular package is causing the failure. The more you can narrow it down...

I may depending on the need and with a lot of caution. If I did run it, I would monitor performance and be on top of any issues that...

Try this query for the backup history and post the results

DECLARE @DBName varchar(128)

SET @DBName = 'YourDBNameHere'

Select a.database_name,a.backup_start_date

,BackupPath = b.physical_device_name

,BackupSizeMB = a.backup_size/1024/1024

,CompressedBackMB = a.compressed_backup_size/1024/1024

From msdb.dbo.backupset a

INNER JOIN msdb.dbo.backupmediafamily b

ON a.media_set_id...

Are you sure it was servers and not just databases?

And it has been a light week.

d'oh

I missed a piece in the documentation. addlogin is for SQL logins only. Grantlogin is for adding windows accounts. That is the reason you were getting the...

have you tried issuing a manual checkpoint to that database?

Will you post the results of this query

Declare @DBName varchar(128)

Set @DBName = 'YourDBHere'

Select db_name(database_id) as DBName,name as LogicalName,physical_name,type_desc as FileType

,Size*8/1024 as FileSizeMB

From sys.master_files

Where db_name(database_id) = @DBName

Just replace YourDBHere with the...

And when you use the brackets?

Thanks Gail. I was sure it would work as you said.

The method chosen (adding to what Ron said) will partly depend on the information you can provide back.

I think we need a lot more info than what has been provided to assist in db design questions such as this.

What is the exact error you received?