Inside the SSIS package you can make use of "On failure" flow to show the users the error

Hi,

Check the below link, this may help you.

error 40-could not open connection to sql server

There are some more system databases are there as mentioned below

Reportserver -...

Try the below article, i think this may help you

Rebuilding Master db

Pls post the setup log file information and the eventviewer information, then only we can analyze whats the exact error.

You have missed out with file option

try using the below command

RESTORE DATABASE test2

FROM DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\test9.BAK'

WITH MOVE 'test' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\test2.mdf',

MOVE 'test_log' TO 'D:\Program Files\Microsoft...

Refer the below link from Microsoft.

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

And also check whether the backup you are having is a valid backup with RESTORE VERIFYONLY command.

Its better to copy the physical files to local disk and attach, since in our case the performace was went down very much as it wholly depends on network traffic.

Hi,

Check for the following

1.) Try connect using correct protocol

2.) Check whether allow remote connections has been enabled

3.) Firewall may block the particular port used for connection

Hi,

Check the below link and rectify your problem.

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

Hi,

Compatibility relies on database level and not server level. When you install SQL2005 all the sys dbs will have compatibility level 90.

You can check the compatibility by

sp_dbcmptlevel 'dbname'

eg. output:...

Can you check how much freespace available in MDF out of 51GB.

Less the freespace available from total MDF file size and this will be you backup size.

Ch[font=Courier New]eck whether SQL service account has modify privilege on the particular file and the folder that it exists.[/font]

You can also specify the machine IP while configuring.

Im connecting using ISQLW and im sure there is no alias for the server

I dono why this occurs in my machine. its getting connected as said above.