I look at the error log all day every day

EXEC master.dbo.xp_readerrorlog 0, 1, NULL, NULL, NULL, NULL, N'desc'

Thank you both! Sorry for poor wording, misuse of terminology, and bad forum etiquette. :blush:

I think I found the answer on http://msdn.microsoft.com/en-us/library/ms180892(v=sql.100).aspx

Rollback operations are also logged. Each transaction reserves space on the transaction log to make sure that enough log space exists...

How does this script handle multiple files and filegroups?

Edit: Does this script handle multiple file and file groups?

Check out Ola's Maintenance solution.[/url]

You can use COPY ONLY option if you need a backup for a test system.

It's the people like you that I would trust. 🙂

google SQL Server 2012 license guide. SQL Server 2012 Enterprise edition is only core based and not CAL. The names of the iso's are probably wrong.

Maybe a proxy account? Or use connection string?

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

User ID=myDomain\myUsername;Password=myPassword;

Just throwing some ideas out there.

Did you ever find an answer? I'm having same issue. Package runs fine when ran manually but when scheduled through sql agent it fails with that error.

Check http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

I've found my issue... My restore script was trying to restore a file that didn't exist.

I would have thought that the restore would error out, instead it restored the database...

Unfortunatly no. default is set to master.

Another note... I've went onto both the production server where the database is being backed up from and the server i'm...

I have the alter database command running right now and it is blocked by -2.

I've executed:

select req_transactionUOW

from master..syslockinfo

and it gives me 00000000-0000-0000-0000-000000000000

but when i try and...

42