Viewing 15 posts - 5,536 through 5,550 (of 9,253 total)
MysteryJimbo (5/26/2012)
Theres a risk of accidentally deleting or loosing the files when in a detached state.
Take a database offline and then try to delete, move or rename one of its...
May 26, 2012 at 4:33 am
Check your cluster validation report. Have you put all related disks for the mount pints into an app group and set the dependencies
May 26, 2012 at 3:49 am
cfradenburg (5/25/2012)
A user (db level) doesn't work without a login (instance level).
It does, but you to use EXECUTE AS
May 26, 2012 at 3:46 am
I've never found a detached database difficult to re attach, unless of course some clown moves the files instead of copying them.
Even with backup and restore you want the...
May 26, 2012 at 3:44 am
sbaker-757360 (5/24/2012)
I tested complete network failure as described above...
May 24, 2012 at 4:06 pm
anthony.green (5/24/2012)
Only SQL authentication accounts become "orphaned"
Unless of course you're crossing domains 😉
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...
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...
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...
May 24, 2012 at 10:45 am
GilaMonster (5/23/2012)
Check your IO throughput. Sounds like the drive is not responding as it should.
+1
GilaMonster (5/23/2012)
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...
May 23, 2012 at 12:43 pm
is this VM sharing host resources?
what version vmware?
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)
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...
May 23, 2012 at 8:14 am
Viewing 15 posts - 5,536 through 5,550 (of 9,253 total)