Viewing 15 posts - 4,516 through 4,530 (of 9,241 total)
shohelr2003 (12/3/2012)
Now I want to change my operating mode to High Performance (Asynchronous) but getting all options disabled.
How can I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 5:12 am
You can just obtain the max id value after toe deletion by using
select max(col_id) from table_name
Then use this to determine the reseed value.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 2, 2012 at 11:51 pm
cracked it have you? 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 1:43 pm
You must ensure that while no cluster is formed that the 2 nodes do not try to access the disks at once otherwise corruption occurs. Simply hold off exposing the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 12:52 pm
sdpages (11/30/2012)
Will these trans log backup be used with my Weekly Full and Daily Diff backups for a Restore ?Please suggest.
thanks.
yes, the log backups taken by the LS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 12:50 pm
SQL SERVER ROOKIE (11/30/2012)
Thank you guys,And how to look for tables in a DB lets say any table with the word "SHIPPING"Regards
SM
This
selectobject_name(object_id) AS TableName
from sys.columns
where object_name(object_id) like '%table name string%'
group...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 12:46 pm
Your post isn't clear but here goes
if you have a log shipping plan in action, ensure that the only transaction log backups are taken by the log shipping backup job...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 11:05 am
if using local system you need to allow the machine account access to the network share
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 11:01 am
What are the specs for each VM?
You have to bear in mind that the host will have an overhead for its OS and the VMWare Workstation Hypervisor before you even...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 10:59 am
you'll typically see this when there aren't enough resources on the host machine to service all the VMs. Can you supply the full spec of your VMWare host?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 9:19 am
This is fairly straightforward
selectobject_name(object_id) AS TableName
, name AS ColumnName
from sys.columns
where name like '%columnname string%'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 6:06 am
abhishekkulkarni1284 (11/29/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 5:58 am
ravinder-317313 (11/30/2012)
we have installed SQL 2K5 With sp4 on windows server 2008 r2(No msdtc needed) successfully.
when we connect using sql virual name on Active node(Through ssms) It succede but whne...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 5:49 am
Do you plan to do an in place upgrade or side by side?
Do you plan to upgrade the hardware for the cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 5:35 am
ramyours2003 (11/30/2012)
i like to configure mirroring to the databases which are in clustered environment how can we achieve this task ?
A simple google search (and i do mean...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 5:34 am
Viewing 15 posts - 4,516 through 4,530 (of 9,241 total)