You can set the maximum size for each file in your filegroup.

The filegroup size is the total of all the files sizes that belong to the group.

I use getdate() purely as a habit.

You can control...

Yes, the account needs msdb access roles as well, SQLAgentOperatorRole.

This will solely rely on the way your DB2 environment and transactions are setup.

Normally it would only read committed transactions. If you DB2 tables and transactions are setup to not...

You data pump succeeds up till the row indicated.

Inspect any form of transformation needed from source to destination and confirm if the...

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other...

do you have sufficient access to write to the destination location?

Try to restore a backup and see what errors are generated.

http://msdn.microsoft.com/en-us/library/ms188902.aspx

investigate the files in you backup....use the link above..

Happy Holidays everyone, drive safe wherever you go, treasure the time with your families.

You can make use of the SP_help_revlogin as well, works quite well....

http://support.microsoft.com/kb/918992

http://lmgtfy.com/?q=differences+between+sql+2005+and+sql+2008

or

http://www.google.co.za/url?sa=t&source=web&cd=1&ved=0CBUQFjAA&url=http%3A%2F%2Fwww.sqlservercentral.com%2FForums%2FFindPost459626.aspx&rct=j&q=differences%20in%20sql%202005%20and%202008&ei=bAELTe22NcmZ8QPVvPm_DQ&usg=AFQjCNHiBAgfPhS9Xu9K5mkupFNH5osqYA&cad=rja

or

USE master

GO

EXEC xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft

SQL Server\xxx\Registration','CD_KEY'

replace xxx with you 100 or 90....

Sorry, just remembered this SP was dropped...

wont work.

Any reindexing/index rebuilts or maintenance plans?

Use the built-in ETL tool....

Right click your destination database and select Tasks, Import Data...follow the steps.....