Viewing 15 posts - 1 through 15 (of 19 total)
Every thing is looks find except QUIET="False" as you told, you are doing silent installtion then its suppose to be TURE.
February 7, 2011 at 12:27 pm
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.
November 17, 2010 at 6:17 am
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...
September 27, 2010 at 11:04 am
Thanks for the reply, but its not the case sencitive database\server.
06:49:09 Database system user [sa] does not have the necessary permissions on the DB server
September 27, 2010 at 10:03 am
This process is might be associated with RESOURCE GOVERNER, that is
new feature in SQL2008 for better resource utilization.
April 21, 2010 at 2:54 pm
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...
March 29, 2010 at 1:10 am
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...
March 26, 2010 at 2:33 am
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...
March 25, 2010 at 12:52 am
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.
March 25, 2010 at 12:23 am
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...
March 25, 2010 at 12:18 am
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...
March 25, 2010 at 12:14 am
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...
March 25, 2010 at 12:02 am
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...
March 24, 2010 at 11:56 pm
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...
March 24, 2010 at 11:51 pm
Please find the same kind of code.
-- TO BE RUN ON SHCBBMS01 SERVER
-- For SQL 2000
set nocount on
declare @server varchar(256), @ctr int
declare @tbllist table (srvr varchar(256),id int identity)
November 11, 2009 at 1:50 pm