Viewing 15 posts - 8,851 through 8,865 (of 9,244 total)
Loner (10/1/2008)
I chose not to detach and attach the database because the database is a production database.
use backup and restore then!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2008 at 3:42 pm
JMSM (10/1/2008)
get all database owners of one specific database.
there is only one database owner, schemas however may be owned by more than 1 object!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2008 at 9:10 am
george sibbald (9/30/2008)
as long as you are using 32 bit SQL server, you will need to enable AWE to access memory over 4GB
and don't enable the /3GB switch in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 3:23 pm
that's what i mean, i'm surprised you haven't seen the old BSOD
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 3:20 pm
net start will show a list of services that have started, you would need to cycle the list looking for SQL server. You could use WMI!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 3:18 pm
vyas (9/25/2008)
How can we administer the failure of log shipping? How can we know what the last log was shipped?
that is why you use a monitor server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 3:15 pm
didn't i already answer this for you :unsure: .
The SP's and Functions are there so no reason why you couldn't perform a server side trace.
Check the following link for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 3:09 pm
Lynn Pettis (9/30/2008)
that will result in a cross join without a where clause.
and as explained will almost certainly produce more rows than you can shake a stick at 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 3:02 pm
the EMC clones will almost definitely be homed on replicated LUNs, the SAN fabric will move data around a hell of a lot quicker than any disk to tape I\O....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 2:54 pm
great minds think alike they say 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 2:31 pm
TRACEY (9/29/2008)
plan what size you need your SAN or disks to be
curious, yulichka doesn't make any mention of a SAN at all :ermm:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 2:28 pm
TBH i'm surprised it's only the apps that crashed.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 2:24 pm
Matt Miller (9/30/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 2:20 pm
remove the /3GB switch from the boot.ini and reboot the server.
This switch is not required and indeed shouldn't be used for machines with 12GB RAM or more
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 2:10 pm
wow, sounds like it should do the job!
what disk config you going for?
how many\large databases do you anticipate?
how many user connections?
how many instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 2:05 pm
Viewing 15 posts - 8,851 through 8,865 (of 9,244 total)