Additionally, Look on to the error message Its Error 8964:

Was there any other alternative in my situation?

as there any other alternative in my situation.?

GilaMonster (7/28/2009)

---

The root cause will be IO subsystem problems. Corruption is (99% of the time) the result of problems somewhere in the IO path. Check anti-virus, check drivers, check HBAs,...

You can get consistency error mostly for

the values might be entered into the database that are not valid or out-of-range based on the data type of the column. In SQL...

Chandu (7/27/2009)

---

Hi Vishal,

I am surprised that without root cause analysis you used dbcc with allow data loss and that too in production. Can you post...

duplicate post was because of site strange behaviour. Gail can you delete one of it...

And so far I did not find that weblink back. Lots of Googling even didn't;t help. What I remember is the subject line was was something like "SQL Server Release...

I got that from a weblink...let me try finding that again and post that here shortly.

Let me put it differently.

1) There is no SQL Server 2010: Gail right in saying here it will be just an addition in BI features of existing SQL Server 2008....

But then what is the purpose of MS saying "from VNET++ onwards we will be completely in the cloud hosting" for databases.?

I know MS already in the field of Cloud...

please provide some details.

If you are in SQL 2005/2008 go to Management> Maintenance plan

1) Pull in the component called "Backup Database Task"

2) Define a new connection to the desired server

3) Select the...

the whole problem seems to be the QUOTED_IDENTIFIER options:

Try this:

SET QUOTED_IDENTIFIER ON

USE DBPROD

insert into [DBLog.dbo.logtabl1]

select * from [dbo.um_tbl1]

go

truncate table [dbo.um_tbl1]

vrabhadram (6/25/2009)

---

thank you,

i have one more issue:

i have a job to archive data from the production to another log database(600 tables). for this purpose i have created the statements for...

Understood.

But Lets say if I am enabling it on one SQL instance which is A/A, will it automatically consider the same on its cluster counterpart?

I agree with Balance. the same setup works for us too. But incase you want better administration here is what you can do:

> design a new database maintenance plan under...