Friday, September 20, 2013

[MS SQL Server] List the available fields in a DBCC command

[MS SQL Server] List the available fields in a DBCC command

List the available fields in a DBCC command

Posted: 19 Sep 2013 11:15 PM PDT

The idea is to run DBCC in its various forms as part of a proactive maintenance program. Any reported errors will then be sent by Email to the relevant administrators for action. The results will have been placed into a temporary holding table and forwarded as required.My question is this: How do I discover what fields a DBCC command populates when it executes? Surely I need this information so I can build the relevant temporary holding tables for each DBCC run?

Extended Events file target

Posted: 19 Sep 2013 07:58 AM PDT

Hi all,I've been reading BOL and searching online for answers, but wasn't able to find any.I'm putting together an event session that has a target of asynchronous_file_target. My questions are:If my max_rollover_files is set to 2, and the max_file_size is set to 2MB, and the first and then the second file are filled up, what does sql server do then? Does it stop the extended event? Does it start writing to file 1? Does it create a new file and delete file 1? Also, is the value for max_file_size in MB or GB or something else? Thanks in advance.

Connection to SQL Server with Access data project failed

Posted: 19 Sep 2013 07:08 AM PDT

Hi, We want to connect an Access adp (Office 2010) from a client computer (Windows 7 32 bit) to a SQL Server 2008 Express (installed on a Windows 7 computer as well) - both in the same domain.Firewall off, antivirus off, ports set to 1433 at SQL Server (0 deleted at dynamic ports), remote activated, named pipes and TCP/IP activatedAccess projects on SQL Server - computer can connect with windows and SQL Server authentification.Access project on Client comuter cannot connect. Server is not listed in the access connection string-windwow (but SQL browser cannot be started at SQL Server under Express - this is disabled). I am entereing either the Server name or also tried with IP Address, tried both authentification modes but then database cannot be selected an an error occurs (no connection to SQL Server, check remote connection,...).We cannot install telnet or Management Studio on Client computer - this is not allowed.Any suggestions would be highly appriciated. Thanks in advance!!Sue

SQL Server backup Failures with TSM \TDP TCP\IP Connection Failure

Posted: 19 Sep 2013 05:54 AM PDT

Sql Server Versions 2005, 2008R2Folks I'm at a loss and the TSM Administrators are also now throwing lines into the water to start fishing. Has anyway had or seen the following errors from the backups 09/19/2013 13:10:13 ACO5436E A failure occurred on stripe number (1), rc = 41809/19/2013 13:10:13 ANS1017E (RC-50) Session rejected: TCP/IP connection failure09/19/2013 13:10:13 ACO5436E A failure occurred on stripe number (0), rc = 41809/19/2013 13:10:13 ANS1017E (RC-50) Session rejected: TCP/IP connection failure09/19/2013 13:10:13 ACO5436E A failure occurred on stripe number (2), rc = 418The failure is random, it can be at the start, middle, end of the backup process. I have looked the IBM Blogs to no help, they just point into a loop within them the blogs and never answer the question. the diserrorlog is no help.So has anyone every encountered this error, and what did you do to get around the error.I see this in about 12 to 15 servers a night. Yes manual backups through the TDP gui does complete normally. But that consumes allot resources...
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog