Viewing 15 posts - 1,891 through 1,905 (of 7,504 total)
We use mount points on almost all of our clusters because of that reason.
We haven't experienced issues with it over the years.
However, you need to take into account you need...
July 10, 2011 at 6:47 am
Tom.Thomson (7/8/2011)
ALZDBA (7/8/2011)
Steve Jones - SSC Editor (7/8/2011)
TGIFActually not so much. Leaving for the UK on Sunday, will be out of touch for most of the next week. Behave.
Keep in...
July 9, 2011 at 2:23 pm
SQLkiwi (7/8/2011)
--- never mind ---
Is that a new "Knock, Knock" ?
July 9, 2011 at 2:19 pm
just to add to the previous replies...
for such kind of maintenance, I always advise to disable the services ( or take the cluster resources offline ) so they don't auto...
July 9, 2011 at 5:14 am
did you take your db offline _before_ the file copies / lun copies?
July 8, 2011 at 10:06 am
FYI:
/*
DMV Database File Size on Disk.sql
*/
Select IVFS.database_id
, DB_NAME(IVFS.database_id) as DBName
, IVFS.file_id
,...
July 8, 2011 at 10:02 am
Elizabeth.Block (7/7/2011)
This is a restore we've done through SSMS gui every month for years. ....
Why aren't you using a sqlagent job with a job proxy account that can read from...
July 8, 2011 at 10:00 am
Steve Jones - SSC Editor (7/8/2011)
TGIFActually not so much. Leaving for the UK on Sunday, will be out of touch for most of the next week. Behave.
Keep in mind to...
July 8, 2011 at 9:52 am
shanila_minnu (7/8/2011)
its 64 bit
ALZDBA (7/8/2011)
...3) if this is a 64-bit instance, don't enable AWE and set max server memory !
Solution,
exec sp_configure 'max server memory (MB)', yournumberofMBforRAM ;RECONFIGURE
go
checkpoint
go
July 8, 2011 at 5:15 am
First question: is your instance a 32-bit instance ??
2) The first thing you need to do before enabling AWE is to set "max server memory" for your instance or it...
July 8, 2011 at 5:07 am
are you shrinking the .log file or one of the .mdf/.ndf files ?
July 8, 2011 at 5:03 am
John Mitchell-245523 (7/8/2011)
... You should be table to build ...
professional dyslexic :hehe:
Happens to me all the time :blush:
July 8, 2011 at 5:00 am
I would check out the applications connection string.
If it states the "failover partner=serverb" it will just be redirected without a problem.
If it lacks the "failover partner" keywords, something is wrong...
July 8, 2011 at 4:07 am
Please elaborate on what you are actually trying to do !
Triggers can perform queries, but keep the transaction scope and locking in mind !
Special objects _in_ triggers are the "inserted"...
July 8, 2011 at 12:56 am
- create primary keys for your tables and foreign keys to support your data integrity !
( very nice ref on how SQLServer takes advantage of this: Do...
July 8, 2011 at 12:42 am
Viewing 15 posts - 1,891 through 1,905 (of 7,504 total)