You can do this way:

This is one time effort and prepare the script for all servers in same way.

update MonitoredSQLServers set MaintenanceModeEnabled = 1 where InstanceName = 'ServerName'

Thanks,

Ashok

Here is the exact error message:

E000exec Test_SP @Test_SYSID=93,@Test_SALE_SYSID=NULL,@Test_SALE_YEAR=NULL,@CODE=NULL,@DESCRIPTION=NULL 1[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'Test_SP'.

I have more than 50 messages like this for different store procedures.

Thanks

AKP

I set the database to right one. Still that error comes.

You can do this by using following ways:

1. copy file using batch script.

2. restore database using tsql script.

3. fix logins using tsql.

Put these steps in sql server agent job steps....

Perfect. I got it.

Thank you so much for your suggestions..

AKP

Thanks for your reply. But Here I want to know what are the security requirements for those abc/xyz domain user accounts if i want to run agent & Integration services...

Thanks all of you guys for your valuable suggestions.

Thanks

AKP

Thanks for your kind reply. But still restore is taking more than 6 hrs if each t-log backup file size is 560KB(total: 240 files). When I saw the restore job...

Thanks for your response. Currently there are some blocking issues on DB server when they use single account. App team is saying if there are multiple account this will not...

This is microsoft recommended figure for Windows 2008 R2 64bit Server. But for windows 2003 Server, you can give 4GB.

Thanks

AKP

As per Microsoft recommendation, You have to give 6 GB memory to Operating System(Window 2008 64Bit). Remaining you can give to SQL Server as Max Memory. we also have same...

I think your source(Installation file) is got corrupted. Try to download fresh copy of sql 2008 or use different copy of sql sever 2008 software and try it again.

I hope...

Don't go for two t-log jobs because while restoring by logshipping job the log chain will not be same and restore will fail. So the best way is configure the...

can you post the screenshot of that error message ? what privileges you have with the installation account ?

Thanks

AKP

I think, first you need to clean earlier attempts from control panel, Then install Windows Installer first, Then install .Net Framework 3.5.1 separately as a prerequisite step to the SQL...