Oliver Hanappi's questions

I'm setting up a Windows Server 2003 for my network. The server has two harddisks, the first will hold the system as well as a data partition, the second should have a copy of the data partition. Is there a tool which can automatically backup all data from the data partition to my backup partition?

The computer does not have RAID and the harddrives do not have the same capacity, but both data partition and backup partition are exactly the same size.

Best Regards
Oliver Hanappi

PS: It would be nice if the software is free or even Windows built in (I'm on a low budget).

I'm a developer and running a SQL Server 2008 SP1 instance (default instance) on my local machine (Windows 7 RC 32-Bit). Sometimes when the program I'm developing sends a query to the SQL Server, the whole SQL Server crashes. The SQL queries are not complex, just simple CRUD queries. When I restart the server, the next query kills him again.

The event log entry states that an error happens because of MS DTC. Unfortunately I don't have any idea why. When I'm using the SQL Server for other purposes through SQL Server Management Studio, I haven't encountered any problems, so I don't think it has to do with my operation system.

Does anybody have ideas why SQL Server crashes? It makes development really difficult, sometimes even impossible.

Best Regards,
Oliver Hanappi

PS: Here is the event log entry.

An MS DTC component has generated an exception. Error Specifics: The process '"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER' hit an exception in a MSDTC related component.
The following exception (0xc0000005) was generated at 0x 00FEAC8C, Pid:7400.
The process is being terminated.
Additional information useful in a debugger:
You can do '.exr 0x0369E930' to display the exception record.
You can do '.cxr 0x0369E94C' to display the context at the time of the exception.

0