Viewing 15 posts - 5,536 through 5,550 (of 9,244 total)
anthony.green (5/24/2012)
Only SQL authentication accounts become "orphaned"
Unless of course you're crossing domains 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2012 at 10:58 am
Its already been said but actually restoring is the best way, however, you can also use
RESTORE HEADERONLY
RESTORE FILELISTONLY
If you can read the filelist and header details there's an extremely good...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2012 at 10:56 am
michael vessey (5/24/2012)
the syntax for rebuild is as followsALTER INDEX [PK_mytable] ON [dbo].[mytable] REBUILD
or to defrag
ALTER INDEX [PK_mytable] ON [dbo].[mytable] REORGANIZE WITH ( LOB_COMPACTION = ON )
For info, you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2012 at 10:53 am
derekr 43208 (5/24/2012)
I know that SQL Server is backward compatible - I can restore a 2005 Database into a 2008 instance.
Is this possible between Service Packs?
Can I restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2012 at 10:45 am
Cool!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 2:03 pm
GilaMonster (5/23/2012)
Check your IO throughput. Sounds like the drive is not responding as it should.
+1
GilaMonster (5/23/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 12:51 pm
bopeavy (5/23/2012)
Error: 17310 Severity: 20 State: 1.
Which cause SQL Server to reboot 4 times during a backup procedure. What I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 12:43 pm
is this VM sharing host resources?
what version vmware?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 12:28 pm
sbaker-757360 (5/23/2012)
We are attaching a LUN and we create one Data Store per LUN, and then create VMware virtual disks.
Bingo, thought so 😉
sbaker-757360 (5/23/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 12:15 pm
sbaker-757360 (5/23/2012)
I have not seen any current ESXi v5 or Microsoft 2008 R2 MSCS documentation saying that our configuration is not supported
yes, you have, the mere fact your cluster validation...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 8:14 am
So your attaching the LUN and creating an ESX data store and then creating VMware virtual disks for sharing amongst the VMs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 8:11 am
ananda.murugesan (5/23/2012)
Please confirm the options which is correct boot.ini file modification.Option -2
boot loader]
timeout=5
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /3GB
Option 2 initially, but bear in mind that not specifying /noexecute=optout...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 7:56 am
sbaker-757360 (5/23/2012)
Our...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 7:41 am
sbaker-757360 (5/22/2012)
shared disks (SCSI bus sharing set to Physical)
This type of shared drive is not supported for Windows 2008 it will only work with Windows 2003 nodes. Hence why...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2012 at 5:28 pm
deep_kkumar (5/22/2012)
Are you able to re-point the applications etc? YESI will try to work on the mirroring option.
Can I know more about other options?
you could also log ship the databases...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2012 at 10:40 am
Viewing 15 posts - 5,536 through 5,550 (of 9,244 total)