thanks Grant

but it basically reinforced the 'only reorganise at low fragmentation' advice generally given?

Grant Fritchey (4/18/2012)

---

I would be very careful about using reorganize as a mechanism for performance enhancements. I've seen tests run by Brad McGehee and it's only of marginal use within...

try reorganise index, its much less intrusive. It can be less effective so monitor your fragmentation.

If your queries are mostly returning small amounts of data a little fragmentation is not...

THE-FHA (4/17/2012)

---

Guys what i am actually trying to achieve is to avoid .bak files from being restored elsewhere by someone who got access to the backup file. So column level...

right click on sql server agent, properties history, you probably need to increase your retention values, in particular job history log size.

You could also have a purge job running via...

I don't know, as a veteran why did you think I need the obvious quoted at me? I found it patronising. You should have just said in your opinion it...

largest table I have had was 1.5 billion rows. That was fine on a server with only 4Gb of memory.

Indexing is very important, for instance I found it useful to...

op didn't say what he wanted it protected from.

you can specify a password when you create a backup, which would then be required to restore from the backup file.

http://msdn.microsoft.com/en-us/library/ms186865(v=sql.100).aspx

this option will not be present in SQL2012

irrespective of the connection string is there a 'use database' statement in the application.

would be worth running profiler to see exactly what happens when you fire up the application

also look for any login failure error messages in the sql errorlog and post the state no here.

you still had this error...........

what is the logins...

what version of SQL are you migrating from?

you should be configuring database mail and using sp_send_dbmail .