Viewing 15 posts - 5,431 through 5,445 (of 9,241 total)
Are the mirroring instances on the same server or separate servers? Have you checked the mirror endpoints status?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2012 at 8:12 am
Michael Valentine Jones (6/20/2012)
execute sp_updatestats
sp_updatestats (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms173804(v=sql.105).aspx
"...sp_updatestats updates only the statistics that require updating based on the rowmodctr...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2012 at 8:02 am
Roust_m (6/20/2012)
Perry Whittle (6/20/2012)What on earth makes you think that? It's no different to any other node failure in a cluster, the instance will restart on a partner node. Where...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2012 at 12:45 am
at what point is the installation at, are there any services installed?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 3:38 pm
sqlbee19 (6/20/2012)
Perry - Thanks for your response.I am using sysindexes table because of column "rowmodctr" is only available in sysindexes.
That is correct, remember though that sysindexes is provided for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 2:46 pm
ran.ovadia (6/20/2012)
I currenty have in my Prod env. SQL2005 SP3 + GDR (9.0.4053) and in test env I have SQl2005 + Sp3 (9.0.4035).
Now i need to upgrade my Test env...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 8:04 am
Welsh Corgi (6/19/2012)
I'm sorry I misread it.It is MB not GB.:blush:
I have been working a lot of hours and I'm tired and it's only Tuesday.
Thanks for the information!
🙂 it's even...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:57 am
The master key has absolutely nothing to do with moving the database!
You need a backup of the certificate and its password and the database backup itself. The master key merely...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:44 am
Roust_m (5/9/2012)
I want to define a policy to make sure every table and every index (including those for indexed views) in the database has "PAGE" compression.
I could only find a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:36 am
the cluster will replicate this change for you, just apply at the active node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:32 am
sqlbee19 (6/19/2012)
FROM dbo.SYSINDEXES SI (NOLOCK)
INNER JOIN SYS.OBJECTS T ON T.object_id = SI.[id]
Instead of using sysindexes, use sys.indexes and sys.objects
The first thing you want to do is to get...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:30 am
what do the jobs actually do??
Try setting the log output on the job steps to get more info too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:21 am
Roust_m (6/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:17 am
Roust_m (6/18/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:16 am
Check the status of your mirror sesion firstly, log records that have not been transferred cannot be truncated and often cause the log to grow wildly.
Also check the status of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 19, 2012 at 8:30 am
Viewing 15 posts - 5,431 through 5,445 (of 9,241 total)