Comments
Sort by recent activity
I'm sorry.
I'm trying to know if both (5 and 6) can run together in the same pc.
Thanks, / comments
I'm sorry.
I'm trying to know if both (5 and 6) can run together in the same pc.
Thanks,
Done! / comments
Done!
Find the problem.
Somehow the local system account whas created: ..luis. (Sql clone server services)
After chanced to Local System, and use open localhost:14145 ask me for user and password and now begin to work.
Is unusual because I have all Red gate products and no one was created with ..luis account.
Cheers, / comments
Find the problem.
Somehow the local system account whas created: ..luis. (Sql clone server services)
After chanced to Local System, and use open localhost:14145 ask me for user and password and now...
Hi Chris,
1) Service is running.
2) when I try to paste sql clone log ans submit de post, I get this error:
"Your post has triggered spam detection. If this is incorrect, please contact support@red-gate.com."
3) Like I said before the error is during Conifugre Sql Clone Server.
After filling all informatios (instance, windows domaind, etc) and press "next" I get "Failed to open........."
Cheers, / comments
Hi Chris,
1) Service is running.
2) when I try to paste sql clone log ans submit de post, I get this error:
"Your post has triggered spam detection. If this is incorrect, please contact support@red...
Hi Aaron,
No. The error is during SQL Server Clone setup. After filled: server name, windows domainuser, password and database I get the problem.
OS: windows 10
SQL : SQL Server 2008R2 Standard Edition SP3.
Thanks,
Luis / comments
Hi Aaron,
No. The error is during SQL Server Clone setup. After filled: server name, windows domainuser, password and database I get the problem.
OS: windows 10
SQL : SQL Server 2008R2 Standard Edi...
Server Unreachable.
The RPC server is unavailable. (Exception from HRESULT: 0x800706BA).
Additional information (from me).
1) I can connect to this server with SMS, EM, QA, Profiler, DTA.
2) I can't use SQL Counters Performance Monitor because X64.
3) I can't connect to this server with Diagnostic Manager from Idera because x64. / comments
Server Unreachable.
The RPC server is unavailable. (Exception from HRESULT: 0x800706BA).
Additional information (from me).
1) I can connect to this server with SMS, EM, QA, Profiler, DTA.
2) I can'...
Hi,
SQL 2000 SP4 Fix 2040.
Unfortunately I've deleted that long query.
Since I'm free lance DBA, I'll try with other customer on Sunday and back with that information.
Other suggestion: Most of the times long queries belong to Response.
Is there any way to avoid that?.
I mean something like Profiler (don't show profiler itself time) / comments
Hi,
SQL 2000 SP4 Fix 2040.
Unfortunately I've deleted that long query.
Since I'm free lance DBA, I'll try with other customer on Sunday and back with that information.
Other suggestion: Most of the...
Done.
Luis / comments
Done.
Luis
I suggest to run
USE yourdabase
sp_spaceused @updateusage = 'TRUE'
and try again.
Just a thought. / comments
I suggest to run
USE yourdabase
sp_spaceused @updateusage = 'TRUE'
and try again.
Just a thought.
I run Standard scheduled job (optimization and integrity) on Monday, Wednesday and Friday at 4.00 and 5.00 am.
So, yesterday (Monday) the job runs fine.
This one is for Integrity : 5.00 am.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 546C75EF-FB62-493F-946E-8D62F8BC7A2C -Rpt "C:\Archivos de programa\Microsoft SQL Server\MSSQL\LOG\DB Maintenance Plan12.txt" -DelTxtRpt 2WEEKS -WriteHistory -CkDBRepair '
This one is for Optimization: 4.00 am.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 546C75EF-FB62-493F-946E-8D62F8BC7A2C -Rpt "C:\Archivos de programa\Microsoft SQL Server\MSSQL\LOG\DB Maintenance Plan10.txt" -DelTxtRpt 2WEEKS -WriteHistory -RebldIdx 10 '
My suggestion is: If the job fail or the job does not running, said for 2 or 3 days, then the Response Recommendation is fine. Otherwise, to me, is a false alarm. / comments
I run Standard scheduled job (optimization and integrity) on Monday, Wednesday and Friday at 4.00 and 5.00 am.
So, yesterday (Monday) the job runs fine.
This one is for Integrity : 5.00 am.
EXECUT...