Viewing 15 posts - 4,981 through 4,995 (of 9,244 total)
Nater (9/19/2012)
Alright I got a few more questions. How exactly do backups work in SQL Server 2008.
Are you talking native backups or 3rd party (Litespeed, Sqlbackup, etc)?
Nater (9/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2012 at 1:49 am
phani112 (9/19/2012)
We also have a similar situation in my current project where we are planning to have SQL MSCS on ESX. The main purpose of MSCS is for hardware failures...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2012 at 1:22 am
sql-lover (9/19/2012)
-I am using smart ReIndex-The ReIndex will run for 1st time
How do you know? Unless you force reindex you could end up reorging some indexes and this will bloat...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2012 at 2:35 pm
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
Viewing 15 posts - 4,981 through 4,995 (of 9,244 total)