Hi,

What are you trying to do here? You cannot backup tempdb database.

That's pretty strange, before replying to your scenario I made a test set up with 2 minutes latency and checked all the tables, I was able to get the info...

eashoori (3/12/2009)

---

Can you tell me if or what should I add to the following script to make sure the script kills all the sessions (if any) on the database...

SQL Noob (3/13/2009)

---

i keep getting these questions wrong when studying for the 70-431

situation is you do full backups on the weekend, diffs on the weekdays and log backups every hour...

So still you can't delete the login? Did you query sys.database_principals and look at what schemas does this login own?

Yepp, Why don't you use the GUI shipped with SQL 2005 itself if you are doing it just for one.

Well done!, you should be proud of yourself. and all the best for your MCITP. Please feel free to post any doubts you have when you are preparing we would...

Do not put Autoupdate stats ON, it does affect your database performance. I would prefer running a job to update statistics now and then after analyzing the data.

TRACEY (3/16/2009)

---

I have NT Login domain\myuser

This user is mapped to a database and schema owner dbo and database role is db_owner.

User couldn't connect so i tried to delete this and...

MichaelJasson (3/13/2009)

---

Server BAYPPSQL1BHC02 has four processors.

On one server I am getting System Processor Queue Length and sql connection issue continuously. To resolve this I increased the 'maximum workers thread'...

If you query msdb..jobhistory table it should show you what databases have been backed up by the agent?

You really need to let us know what your requirements of your offsite server or your...

Also, I would want to add on this after looking at the code. For your large tables,The Fillfactor is 90%, I take it your are defragging them frequently. If you...

Error is clear you dont have the database "Sharepoint_admin...." databse present under sys.databases catalog view. MAke sure the database exists before querying it through the command.

nikhil.verma (3/16/2009)

---

Hello

Can anyone please tel me the exact difference in simple and full recovery models ( from the architectural point of view) . Say if i running DML operations...