The current size of the bak file generated from my database is 6MB so it's a small database. The current time to execute a backup is < 2s.

I don't...

Thanks Gail - that was the problem.....

I tried:

alter user [MyUser] with login [MyLogin]

However, SS returns the following error: "Incorrect syntax near 'MyLogin'."

I tried executing this query in the main app database as well as...

Setting owner to SA fixed it for me - thanks!

This is the error logged in the Maintenance Plan job history:

The job failed. Unable to determine if the owner (MYDOMAIN\mynwuid) of job MaintenancePlan.Subplan_1 has server access (reason: Could not...

I've created a Maintenance Plan for my database. Everything looks correct. It should be scheduled to run every hour and save the backups to my C:\PROD_DB_BAK\ directory. ...

I read the first article posted to this thread and it did seem like a good starter thread.

First things first, I'm going to attempt to create an SSMS...

GilaMonster (10/29/2011)

---

sqlguy-736318 (10/29/2011)

---

Based on what I've read a simple backup should be done frequently and a full backup should be done during off-peak times.  A simple backup is essentially an...

Ninja's_RGR'us (10/22/2011)

---

AccidentalDBA:) (10/22/2011)

---

Depending on what you are doing i like to user variable temp tables, there is no need to drop them at the end because once the script as...

AccidentalDBA:) (10/22/2011)

---

Depending on what you are doing i like to user variable temp tables, there is no need to drop them at the end because once the script as completed...

Thanks Ninja - I assumed that table variables would always have better performance than temp tables but based on your emphatic NOOOO it sounds like you have a lot of...

Thanks for your replies everybody. Sounds like table variables should be used instead of local temp tables. Table variables seem to have a smaller footprint and local temp...

PK is the default clustered index isn't it?

Thanks everybody for your help - the problem was the end users - I finally forwarded the credentials to a developer user and he was able to show the other...

ghanshyam.kundu (9/9/2011)

---

i think that one, where u r stucking, just start it once and try it should work, i also have faced the same problem. i have done the same...