Viewing 15 posts - 196 through 210 (of 1,154 total)
Mangesh Raut (3/18/2014)
I have created a job with same package but pointing to Dev Server and running under the user say XYZ this job is running properly...
March 19, 2014 at 9:59 am
Looks like this is the culprit ..
RayStationClinicDB_4014D2.200.002014-03-10 19:00:30.0002014-03-10 19:00:53.000NULLNULLNT AUTHORITY\SYSTEMMGHROSTOR3\RAYCLINICALMGHROSTOR3 {B780C3C1-040A-4E93-820A-E9F07AF829EC}3
You have NT backups (VSS backups) running on the server that was backing up all DBs as initially suspected. Those...
March 19, 2014 at 9:51 am
dbalmf (3/19/2014)
I don't think thats the one you are after, the backup I'm questioning is running at 19:00. what was in the SQL Server Logs at the date and time...
March 19, 2014 at 8:30 am
felix150h (3/18/2014)
But what are the chances to be hired merely from studying the books and some theory knowledge? What I'm trying to say is just by...
March 18, 2014 at 6:48 pm
That's a good one recommended by Brain.
Also try to get some SQL Server DBA training. And here is a list of good books for SQL DBA.
http://www.brentozar.com/best-sql-server-dba-books/
Free books are available here...
March 18, 2014 at 1:52 pm
obtllc (3/15/2014)
The teams are grouped as follows:
Best player (largest db) - group 1
Second best (second largest db) - group 2
Third best (third largest db) – group 3
Fourth best (fourth largest...
March 18, 2014 at 11:34 am
glugingboulder (3/17/2014)
I believe Vmware ESX 5.5 supports a maximum of 5 nodes in a windows cluster, that's what made me think...
March 18, 2014 at 11:27 am
selvakumar.sms (3/18/2014)
we are manually doing for long time,but i need to automate that one.
You can either use a start up stored procedure or run the command as a separate step...
March 18, 2014 at 11:02 am
rajemessage 14195 (3/14/2014)
Q) We know DBCC DROPCLEANBUFFERS automatically flushs it self , based of memory and buffer/catch hit ratio.
Please tel me how and when this gets flushed or not used...
March 18, 2014 at 10:17 am
What's the problem that you are experiencing ? Are you getting any errors ?
--
SQLBuddy
March 18, 2014 at 10:07 am
Try this .. You can add a filter for Backup Location in the Where Clause ..
SELECT...
March 18, 2014 at 10:06 am
kaplan71 (3/18/2014)
The problem that I reported has occurred again, even though I modified the Maintenance clean up to remove files that were older than two weeks. I checked the...
March 18, 2014 at 10:02 am
DVSQL (3/17/2014)
March 18, 2014 at 9:35 am
March 18, 2014 at 9:29 am
Try to use SQL Server 2008 R2 Enterprise Edition slipstreamed with SP2.
http://msdn.microsoft.com/en-us/library/cc707783(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms144259(v=sql.105).aspx
--
SQLBuddy
--
SQLBuddy
March 18, 2014 at 9:21 am
Viewing 15 posts - 196 through 210 (of 1,154 total)