Viewing 15 posts - 4,411 through 4,425 (of 9,244 total)
jitendra.padhiyar (1/8/2013)
@Penny
That's ok mitundra 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2013 at 2:54 am
If you have more than one file restart the instance afterwards to kickstart the proportional fill from equal file sizes.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2013 at 1:42 am
To get details of table\index sizes on SQL Server 2005 onwards use the following script,
SELECTOBJECT_NAME(i.object_id) AS TableName
, ISNULL(i.name, 'HEAP') AS IndexName
, i.index_id as IndexID
, i.type_desc AS IndexType
, p.partition_number AS PartitionNo
,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2013 at 1:37 am
b.ammad (1/7/2013)
I have a 2 node Active/Passive cluster mounted in Windows Server 2008 R2. Currently on the active node there's a SQL Server DB Engine instance running. SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2013 at 1:30 am
I can't say I've seen that before, are you sure you modified the xml file the same on all nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2013 at 8:49 am
iamsam.sandeep (1/6/2013)
HI.Just wanted to know if there is any difference betwen Sql patching in 2005 and 2008 Cluster evn
Not just the patching but the installation of the product...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2013 at 3:53 am
balasach82 (1/5/2013)
[Taking backup of db and restoring the same db and changing the file location while restoring]
Example:
Database: Inventory
Backup Inventory
Restore Inventory (replace existing Inventory...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 1:45 pm
most times a differential backup will do the job 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 11:26 am
Contrary to popular belief you do not need to stop SQL Server, there, that's that over with 😉
To move the database files perform the following;
get the logical filename and current...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 11:24 am
you need to change the node IPs first so that the cluster networks are updated with the new IP\mask. Once this is done change the virtual IP for any client...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 11:08 am
Are you just changing IP addresses or are you moving domains too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:42 am
Have you checked the job schedules?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:40 am
did you run the query above?????
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:26 am
SQL server will take care of itself.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:25 am
KcV (1/4/2013)
I have just shifted my database of sql 2000 to sql 2008 64 bit after running Upgrade adviser.
then i run DBCC DBREINDEX in all tables.
After that when i checked...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 5:07 am
Viewing 15 posts - 4,411 through 4,425 (of 9,244 total)