You will definitely get help if you post under BUSINESS INTELLIGENCE section.

Thanks Gila...You are really g8 🙂

Please check the log file mentioned in that error message and post it here

Thanks for the reply

Hi Gila,

Please correct me if I am wrong

What is the remote query timeout in SQL Server properties?

Hi Ddonck,

I have a small doubt ..how you shrink the DB without starting the SQL Server?

As mohit said..the databases will be in different path..You can rectify the error by copying all the .mdf and .ldf files to the path which was in old server and...

I mean SQL Server property.

I dont have any idea about .net but if something like timeout is there you can also look into that...

Why can't you try installing an Express Edition and then restore your DB .

Since your DB is less than 4Gb you can use SQL Server Express Edition and Express Edition...

Log shipping is there in SQL Server 2008.

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

Check whether they have specified any particular amount of time for query timeout.

Think Reporting service can be connected only by windows authentication.

Create a windows user in server b which should be the same as in server A

Check the mail server is up and running ..Also check whether the account 5 is properly configured.

What you mean? :hehe:

You can divide the backup into different files(striped backup) like if u have a 2GB DB,take backup to two file like

backup database DB_name to disk='path.file1',

...