Viewing 15 posts - 61 through 75 (of 177 total)
Sourav (7/15/2009)
No, no updated are happening at Distributor end!
I think LeeM was asking about the Subscriber (destination DB).
Are the data in the replicated tables onthe subscriber side updated ONLY from...
July 15, 2009 at 2:20 pm
On your Secondary/Primary Server, run the following
DELETE FROM msdb.dbo.log_shipping_monitor_secondary
WHERE secondary_database='YOUR UNWANTED DBNAME'
DELETE FROM msdb.dbo.log_shipping_monitor_Primary
WHERE Primary_database='YOUR UNWANTED DBNAME'
July 15, 2009 at 1:45 pm
Not sure whether the OP fixed the scripts or not.
Spent some time today and got the below scripts working.
The cause of the issue is that FOR XML doesn't handle...
July 15, 2009 at 11:32 am
Try this,
replace
td = FreeSpacePct,
With td = case when FreeSpacePct >10 then '{font color="green"}{b}'+FreeSpacePct
+'{/b}{/font}' Else '{font color="red"}{b}'+FreeSpacePct
+'{/b}{/font}' END,
Editor: Replaced brackets with curly braces.
July 14, 2009 at 11:33 am
luckysql.kinda (7/9/2009)
Anyone can guess the reason of logshipping job failure:Procedure or function usp_LogShipping_delete_backup has too many arguments specified. [SQLSTATE 42000] (Error 8144). The step failed.
I would check the definition...
July 9, 2009 at 12:54 pm
Interesting to read this and I did some testing on this.
1. I logged in with my Windows Domain login having SYSADMIN, changed sa password and click other logins and could...
June 19, 2009 at 10:10 am
If it is a clustered SQL Server, you'd better manage the failover from the cluster administrator by moving group instead of simply shutting down the SQL service.
June 18, 2009 at 11:41 am
No, it is not a table. It is a view, a view that you can not see from the management studio.
But if you run the query, it should return the...
June 2, 2009 at 1:53 pm
that's the largest font I've ever seen on the forum. 😀
June 2, 2009 at 12:49 pm
Did a profiler when I clicked through the GUI Maintenance plans and got this query which returns what you are looking for:
SELECT
s.name AS [Name],
s.create_date AS [CreateDate],
s.owner AS [Owner]
FROM
msdb.dbo.sysmaintplan_plans AS s
ORDER...
June 2, 2009 at 12:43 pm
One thought on How to query the archived data.
You can archive the data onto a different server and refer to them in your PROD/LIVE with SYNONYMs.this way, you will...
June 1, 2009 at 12:45 pm
I think I got the following code from this forum and it would retrieve the AUTO GROW info from the default trace.
Please try this..
SELECT
trc_evnt.name
,dflt_trc.DatabaseName
,dflt_trc.ApplicationName
,dflt_trc.TextData
,dflt_trc.FileName
,dflt_trc.LoginName
,dflt_trc.StartTime
FROM sys.traces T (NOLOCK)...
May 29, 2009 at 7:06 am
Type in Holiday Table in the upper right Search area on this page, and hit Go. You would get a lot hits.
May 26, 2009 at 1:42 pm
Open Book On Line, search 'add more data files'.
May 14, 2009 at 11:27 am
Open a Profiler session on the database side and then run the app
See what commands are being sent to DB when those duplicates or inacurate results are pulled to the...
May 13, 2009 at 3:03 pm
Viewing 15 posts - 61 through 75 (of 177 total)