Ninja's_RGR'us (6/9/2011)

---

Wow this is wrong on so many levels.

Do you have auto_close or auto_shrink on?

Please stop using sa for the connection if possible.

Make sure you have auto_create /...

Martin Cairney (6/9/2011)

---

PAE is required ins case to address memory above 4GB. Rebuilding as 64-bit Windows would remove this option.

With PAE enabled then you can make use...

Good point on TempDB. Can I move tempdb just like I did the User db or is it more involved?

Ninja's_RGR'us (6/1/2011)

---

Why move the whole thing?

Just move the user databases to the new drive.

quote]

I'm not sure I understand you... I could be mistaken but wouldn't I want to move the...

lol thanks Ninja... I figured it out the same time you were posting!

EXEC isp_Backup @path = "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup", @dbType = '-AdventureWorks', @bkpType = 'Full', @retention = 5, @liteSpeed = 'N'

Needed double quotes...

Well I was able to get it to work by specifying a NON-8dot3 path.

c:\Progra~1\Mi6841~1\MSSQL.1\MSSQL\Backup

which eliminates spaces in the path name. Any ideas why this worked?

Got it. Thanks guys!

Ninja's_RGR'us (5/24/2011)

---

No the size of the log on the file system should basically never change unless you see a problem down the line and decide to grow it.

The free space...

Steve Jones - SSC Editor (5/24/2011)

---

Gail is correct, the shrink is bad, and the reorganize will rebuild indexes. You can read here:

http://msdn.microsoft.com/en-us/library/ms188964.aspx

When that runs, it will require space in the...

GilaMonster (5/24/2011)

---

There's your database shrink. Turn...

Thanks Gail!

I am not as familiar with Enterprise Manager but I was able to find the Database Maintenance Plan and there is a tab called optimizations that does have 'reorganize...

I feel embarrassed now... It has another instance that I was not aware of.

Thanks guys!

Lowell (5/24/2011)

---

do you have an additional instance of SQL on that server? maybe the isntance is...

Pam Brisjar (5/12/2011)

---

Much better to set to single user mode.

ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

No, users will not become "orphans" by kicking them off the DB. They...

If I kick...