Every thing is looks find except QUIET="False" as you told, you are doing silent installtion then its suppose to be TURE.

QUIET="TURE"

Please try..it

Thanks for the replay,

But problem is that user want the data should be reflected in every 15 mins and when loc1 goes down the loc2 should be up and working.

once...

Ashish,

When I'm trying to fetch the records by right client is working for me and when its fetching through application ....failure.

The database name is automatically fetch by application we're not...

Thanks for the reply, but its not the case sencitive database\server.

Complete Error

--------------

06:49:09 Database system user [sa] does not have the necessary permissions on the DB server

06:49:09...

Hi Raymond

This process is might be associated with RESOURCE GOVERNER, that is

new feature in SQL2008 for better resource utilization.

Regards,

Nitin Gupta

Yes, its right very first step is find out the problem root cause but if you not have any logs and you are unable to find out the RC, wt...

Might be it's not work in this case but I have done this previously as I got my database is in recovery mode. I just stop the SQL services, rename...

According to my previous experience I faced this error many times and its failed just because of disk space availability. check your disk space and make room for the backup...

There is one simple option as well, If you want to distribute all your information publically, do one thing assign the read permission to public role for your database.

In such...

First of all its totally depends on your environment but as per standard practice System Databases (Master, Model and msdb) should in Full recovery mode.

As all of that databases recording...

Hi,

No problem if you are going to move your databases through dynamic script for every database, Its takes time and rick too.

The better way to move is write a dynamic...

Hi,

If you are sure that, there is no recovery is started from your end and if the environment is not associated with production In such case you can follow the...

Hi,

Yes, In same cases multiple backup is available but there is possibilities of process level blocking and its better to schedule the backup on overlapping time interval or after completion...

Hi Sandhya,

If you are struggling with High CPU uses then it might be a problem in production environment, according to the best practice or suggested by Microsoft you have to...

Please find the same kind of code.

-- TO BE RUN ON SHCBBMS01 SERVER

-- For SQL 2000

set nocount on

go

declare @server varchar(256), @ctr int

declare @tbllist table (srvr varchar(256),id int identity)

insert...