I have it running on MS SQL 2000 and Windows 2000 and 2003. The 2000 server
seems to crash a lot, so I had to write a program to check every so often,
and restart the service if it crashed. Unfortunately, setting up the
recovery in the service properties doesn't work. I have had 2 Windows 2003
servers with the same problem, but then I have one that has been running for
a few months without a single crash. I then set up SQL Replication so that I
only have to mess with one db.
Here is the SQL Script for creating the table:
CREATE TABLE [dbo].[records] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[domain_id] [int] NULL ,
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[content] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[ttl] [int] NULL ,
[prio] [int] NULL ,
[change_date] [int] NULL
)
There was an issue with the table and I do not recall what it was. But there
were no errors, it just wouldn't work. It boggled my mind for a while. Then
I figured it out. I should have written it down!
I even wrote a vb script to import all of my MS records into the database.
So if you need help with that, I can help you out.
If you have any problems let me know. I seem to be one of the only ones
running Windows.
Regards,
Michael C. Gates
www.gateshosting.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Adam Bazylczyk
Sent: Friday, October 27, 2006 3:17 PM
To: [email protected]
Subject: [Pdns-users] powerdns on windows with mssql
I try to use MS SQL database and become query errors.
Can anyone help my by configuration?
I think, MS SQL is more stabil than Access?
--
regards
Adam Bazylczyk
_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
