Viewing 15 posts - 7,066 through 7,080 (of 9,244 total)
GilaMonster (6/8/2011)
it's 0 times in 6 years.
wow, as often as that Gail 🙂
bopeavy (6/8/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2011 at 11:57 am
Perry Whittle (6/8/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2011 at 9:19 am
Although you have removed the file it cannot be truly dropped until you restart the database, as this is tempdb you must restart the SQL server services (no reboot required)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2011 at 8:20 am
Perry Whittle (6/8/2011)
what command did you use to drop the files?
:Whistling:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2011 at 7:56 am
what command did you use to drop the files?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2011 at 7:11 am
rahulr.sharma (6/2/2011)
My motive here is to look for a means to change the Security domain groups that are used for the Clustering services, after the installation is performed.
These...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 4, 2011 at 1:02 pm
When moving user databases you dont need to detach them at all.
Issue the alter database modify file statements which will set the new paths. Take each database offline in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2011 at 1:16 am
Typically you dump the trace file output into a SQL server table and then query against that
USE Mydb
GO
SELECT * INTO mytracetable
FROM fn_trace_gettable('c:\temp\mytrace.trc', default);
GO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2011 at 1:20 am
alan.fisher (5/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2011 at 1:09 pm
Hi
both 64k and 256k are optimal stripe sizes for SQL Server. The theory behind the 256K stripe size is that a larger stripe size generally incurs less I\O with 64k...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2011 at 12:28 pm
have you run DBCC checkdb against your system databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2011 at 12:02 pm
at a wild guess i would say the original disk locations do not exist on the new server.
Does the new server have the same drive letters and paths?
If not you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 12:44 pm
again, I'll reiterate, as long as the model database is available
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 10:13 am
do you mean orphaned database user?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 10:11 am
for Tempdb you don't need to do anything. Tempdb is recreated each time SQL Server starts. It does however rely on the model database being available.
If you remove the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 8:57 am
Viewing 15 posts - 7,066 through 7,080 (of 9,244 total)