1
vote
2answers
195 views

what would need to change on IIS for SSL Enabled SQL server

I have IIS set with windows intergrated security, the intranet c# web application connects database with trust connection. Everything works fine until we enabled SSL on the database (Sql server 2008), ...
0
votes
1answer
79 views

automatic backup [duplicate]

Possible Duplicate: how to get database backup automatically i want to have automatic backup in my program.it means that for example every 30 minutes a table that contains backup schedules ...
5
votes
2answers
2k views

DB auto failover in c# does not work when the principal server physically goes offline

I'm setting up DB auto failover in C# with SQL Server 2008 and I have a 'high safety with automatic failover mirror' using a witness setup and my connection string looks like "Server=tcp:DC01; ...
4
votes
1answer
252 views

Backup database at certain intervals?

My client would like to have the database backed up several times per day, as well as the ability to backup the database manually. I've created a page to backup the database manually, it just calls a ...
0
votes
2answers
107 views

repair database [duplicate]

Possible Duplicate: repair suspect database my sql server 2008 told me that you database is suspect and I can't see my tables or my data what should I do ?
2
votes
3answers
1k views

SQL CE thread unsafe - alternatives?

I have discovered that SQL CE is not thread safe: SQL CE objects are not thread-safe and are not thread affinitive either. If an instance of SqlCeConnection or SqlCeTransaction is shared across ...