I have a SQL 2000 server running on a Windows 2000 member server with the latest service packs etc.
The main database file is around 45Gigs which is larger than desired.
However, a second hard drive (sata) has been added so that backups can be run. However, the server crashes 10 minutes after the following item appears in the log:-
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'xp_sqlmaint'.
0000: c0 1f 00 00 0a 00 00 00 À.......
0008: 05 00 00 00 44 00 42 00 ....D.B.
0010: 53 00 31 00 00 00 07 00 S.1.....
0018: 00 00 6d 00 61 00 73 00 ..m.a.s.
0020: 74 00 65 00 72 00 00 00 t.e.r...
So far the system swap file has been moved to the new drive and the power supply replaced.
I have also tried to disable the Maintenance schedule but given the above it looks like something is still running that is crashing the system.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful.
Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.