Ofcourse not! I would recommend you to insert such a huge record set in batches otherwise your recovery model setting and else will...

I have never tested this but I assume all drive settings have to match exactly for this to work.

[/Quote]

Yes, it is mandatory to have the same drive letter\Settings on both...

Hello,

I totally agree with Michael, Well pointed out the issues with shared service account.

Infact it is always a good practice that you get at least 2 service accounts created per...

For me it depends on the requirement. There are a few operations which linked servers can manage very effectively. Like creating partioned view where you need to pull data accross...

Hello IAN,

As i mentioned service restart could cause corruption (if not planned properly) is associated with accidental Server shutdown. I forgot to complete my comment.

I have seen in past that...

Are you using any backup tool or it is just a native sql backup.

It seems to be native though. but just wanted to confirm.

Also, do you have sufficent RAM available...

You can try this.

Create a view with same name as table name in differenct schema at databaselevel.

and then set this schema as default schema for the user .

This would make...

One more thing i would like to add here is that , restarting sql server services is infact a very bad idea, It increasing the chances of page corruption as...

I totally agree with Gail . Infact i have seen the downside of enabling light weight pooling.

Once we tried this option on one of our production Enviornment (SQL SERVER 2000...

Also, If it is a named instance make sure that SQL SERVER BROWSER SERVICE is Running.

I have personally noticed that sometime the RedGate backups continues to run. And even if you will see the RedGate viewer it will show that the backup is still running.

Do...

Your trigger logic is wrong .

If you see you have created a trigger for update on Employee table.

Which means a trigger will fire every time an update occurs on (Employee)...

Also, check if some full\differential backup job is running during that time. And also are you using some external tool for backups or just native backups because when you run...

Both, As i mentioned earlier it was bundled with sql server in earlier versions...

The chances of data loss is minimal , but it also depends on how you...