Viewing 15 posts - 6,766 through 6,780 (of 9,241 total)
take a look at this article
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:46 am
Minaz Amin (8/23/2011)
Generally standby ( using mirroring or Log shipping ) will be in read only mode.
A mirror database will only be read mode if you use database snapshots and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 12:51 am
Lowell (8/23/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 9:27 am
It's consistent, i'll give it that. It's the same in SQL Server 2008 R2 management studio 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 6:39 am
i see what is confusing the OP now
go into the shrink file dialog and select the log file and release ununsed space, then script action to new query window. It...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 6:10 am
GilaMonster (8/23/2011)
p.s. TruncateOnly on shrink is ignored for log files. It's only a valid option for data files (see BoL)
good catch Gail i totally missed that bit 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 6:04 am
which hyper visor are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 5:50 am
MarvinTheAndriod (8/23/2011)
I am shrinking the log file. When scripted out it comes up with the command line:DBCC SHRINKFILE (N'HCMPRD88_Data' , 0, TRUNCATEONLY)
it looks like youre trying to shrink the log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 5:20 am
MarvinTheAndriod (8/23/2011)
Perry Whittle (8/23/2011)
are you referring to the option to release ununsed space in the database shrink dialog?Yes this the option, im looking at
Are you shrinking the database or an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 5:12 am
are you referring to the option to release ununsed space in the database shrink dialog?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 5:02 am
check the Windows application event log for messages
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 3:58 am
yes, terminal services does not affect sql server agent jobs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 3:39 am
Erik Hansson (8/23/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 3:28 am
roughly how many rows do you delete, update, insert?
If you dont absolutely need to clear the whole table then dont use the truncate, the truncate will be fast but the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 3:23 am
Loner (8/22/2011)
If I use data mirroring, would it be better?
no, you cannot update the mirror unless you failover to it, but then its no longer a warm standby!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2011 at 2:04 pm
Viewing 15 posts - 6,766 through 6,780 (of 9,241 total)