It depends on the queries you run, Indexes are very good for select statement, Indexes are not good for DML statements if you are expecting to many DML changes don't...

nadersam (3/13/2010)

---

I am sorry for the late reply my windows crashed and i had to reinistall everything :(.

i ran dbcc opentran and nothing came up , anything else to check...

nadersam (3/11/2010)

---

Thanks for ur reply

The thing i am confused about is that application has finished loading data already and function using this SQL has finished execution , why is the...

Yes, as others said drive should be in SQL server service resource group, check with windows team they can fix this for you.

Let me tell you how to make restore process easy in case you have to restore database.

From your questions looks like you have to change back plan.

You said back up...

Adding to it, Indexes are not good for DML statements, what method are you using to insert data? Is it SSIS or from application ?

GilaMonster (3/13/2010)

---

Why not? Detach/attach and backup/restore will result in the same thing. A database converted to the new version on the...

There is an temporary table in the database already that all, where is the create statement in SP? run drop table statement before creating temp table from store procedure.

mathias-ruehn (3/12/2010)

---

hi gtr,

before migration i created new dbs with the same names

and tried to recover from backups who went good on the old sql server.

yes, that was different account on...

Looks like Merge replication will suit your requirement not peer to peer, elaborate your business requirements we can suggest you which replication.

From BOL

To avoid potential data inconsistency, make sure that...

I would set up AD group and grant permission to the group and add users to that group.

Asif-414084 (3/12/2010)

---

I'm surprised there's no utility to do the DTS to SSIS conversion? So I really have to re-write the SSIS packages? 🙁

Also the new SQL server 2008 server is...

5. In SQL Server Configuration Manager, set the SQL Server service to use “domain\SQL_Srv1_Agent” as the log on account. Clicked OK. I was presented with a WMI Provider Error:...

I think those groups should do it for now.

It better to have SQL services domain account and SQL agent Domain account as well, it is not recommended run services under DBA's admin account.