Viewing 15 posts - 1 through 15 (of 45 total)
There is so much stuff out there for questions like this. Should really start with Books online and try to understand why you are getting the error rather than just...
February 6, 2012 at 6:46 am
Definitely need to elaborate on that!
However, if I was to assume a couple of things and guess that you have been posed that question from a developer then yes it...
February 6, 2012 at 6:25 am
I Agree with Paul above...
Backup strategy's should be based around business continuity and important of the data, and the impact data loss would have.
November 16, 2011 at 1:35 pm
mobgrazer 98125 (11/15/2011)
... sometimes it gets hammered an hour. Weekly and sometimes bi weekly huge amounts of data gets dumped into the data base.
Hi,
What do you consider...
November 16, 2011 at 1:14 pm
in PL/SQL:
BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'DBSCHEMA.JOB_NAME'
,start_date...
November 16, 2011 at 12:37 pm
Can you clarify what you are trying to achieve?
datatypes can be controlled through CAST/CONVERT but not sure if this is what you are asking..
November 16, 2011 at 12:30 pm
Not fully understanding what your asking for, but if you want to see undistributed commands then run:
use [distribution]
go
select d.*, a.article, s.name from MSdistribution_status d
inner join MSdistribution_Agents s on d.agent_ID...
November 16, 2011 at 12:24 pm
I had the same issue with both Token-based and Login-based authentication.
Ive blogged my solution here:
http://dbamohsin.wordpress.com/2011/09/06/token-based-server-access-validation-failed-with-an-infrastructure-error/[/url]
if you dont want to read that then run this code for the user experiencing issues...
GRANT...
September 6, 2011 at 3:09 am
Hi,
I had a similar issue until about ten minutes ago.
Why it happens i dont know... but read the following post on how to fix it - http://www.sqlservercentral.com/Forums/Topic125951-7-2.aspx
In...
February 10, 2011 at 8:59 am
As far as i know, the modifications you make in Replication Monitor are session based.
to make permanent, create an alert or two to manage replication latency
Performance conditions are:
MSSQL$MYINSTANCE:Replication Dist.|Dist:Delivery Latency
MSSQL$MYINSTANCE:Replication...
February 10, 2011 at 8:21 am
Stop all activity on the database
Stop replication
delete subscription (no subscriptions must exist on the publication otherwise it will require a new snapshot)
drop article
recreate subscription with no initialization
restart replication
February 10, 2011 at 8:07 am
Heres hoping ive understood what your asking for.....
WHat kind of connection string do your app servers use? If they are hardcoded IP's or host names, then a redirect is not...
February 10, 2011 at 7:56 am
Are connections being successfully made to the SQL Server? are the symptoms occurring on more than 1 sql server or more than 1 database... The first steps would be to...
February 10, 2011 at 7:40 am
ive tested the above theory and works successfully with replication intact.
alter database REPTEST set restricted_user with rollback immediate;
ALTER DATABASE REPTEST SET OFFLINE;
ALTER DATABASE REPTEST
MODIFY FILE ( NAME =...
January 4, 2011 at 9:32 am
In that case, your suggestion about scheduling the log reader would make sense.
Ensure you consider the following
1) The size of the transaction log during the batch - it will...
December 1, 2010 at 1:53 pm
Viewing 15 posts - 1 through 15 (of 45 total)