Viewing 15 posts - 4,981 through 4,995 (of 9,241 total)
switching to bulk logged will minimally log for an index creation same as simple and won't break the log chain, if its a reorg its fully logged regardless 😉
So, are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2012 at 2:04 pm
Have you checked Books Online??
Before just going and enabling compression check the pre reqs and restrictions as there is an overhead and sometimes a performance impact.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 9:43 pm
There's little point moving the masters log file. Best to always keep the master files in one location as with model and msdb too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 9:40 pm
Grant Fritchey (9/18/2012)
I agree, read Perry's stuff.
Hey thanks Grant, i appreciate the vote of confidence
With AlwaysOn features it literally consolidates the functionality of mirroring and failover clustering into one neat...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 6:55 am
SQLSACT (9/18/2012)
Grant Fritchey (9/18/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 6:06 am
Satish-1028188 (9/18/2012)
Thanks Sudhakar, yes (in last few cases) it was in-between t-log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 5:27 am
alanspeckman (9/14/2012)
Why would SQL Server restart when DTC is failed over, especially when DTC isn't even used according to transaction statistics in the Clustered DTCs folder under Component Services?
Service dependencies...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 5:24 am
Sudhakar Vallamsetty (9/18/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 5:21 am
when are you doing this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 5:18 am
Satish-1028188 (9/18/2012)
I have logshipping configured in SQL Server 2008 boxes, some times this goes out of sync for some of databases (few of them are quite large in size) due...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 4:44 am
great, just make sure to pay attention to what you're doing and it will be fine
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 4:20 am
runal_jagtap (9/18/2012)
What are the steps for setting the tempdb datafile & log files to other locations???
The same as i detailed above 😉
You just need to restart the SQL Server service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 3:28 am
runal_jagtap (9/18/2012)
Thanks Perry 🙂Can you give an example, rough pathfilename etc for this syntax query?
ALTER DATABASE mydb MODIFY FILE(name=logicalname,
FILENAME='new path and drive\the originalfilename.extension')
Yes sure. Let's a ssume i have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 2:06 am
This is very easy and in fact I have a request for change for exactly this to complete this week in the organisation where I work. Follow these steps;
get the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 1:28 am
jdbrown239 (9/17/2012)
Could I go with repairing just the tables? Either checktable repair_allow_data_loss or checktable repair_rebuild?
Just in case you didnt see my previous answers here it is again
"restore the database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 11:57 pm
Viewing 15 posts - 4,981 through 4,995 (of 9,241 total)