Thanks for the replies. Most of the tables do not have clustered indexes, so I guess the HEAP cannot be defragmented. As for the others,... I had built a query...

"..Explain the risks of not doing the things you said. Let the Boss decide what risks to take or not and do your best to protect the boss where...

I thought I had run sp_help_revlogin_2000_to_2005 , but still didn't see the databases assigned to the sql account. I dropped the SQL login and re-ran sp_help_revlogin_2000_to_2005 and I think...

Nikhil (3/13/2009)

---

create one account on ur machine right click my computer go to manage create user give name SQL_proxy..

now add that user to administrator gr over there

now create same user...

Sorry, I don't quite get it yet. I have a Domain account I can use "Domain\SQL_Proxy" but in 2005, I'm not clear on how to make use of it for...

Gift Peddie (3/13/2009)

---

xp_sqlagent_proxy_account sets or retrieves the proxy account for the instance on which it is executed.

The SQL Server service for that instance must be running under a Windows...

I think it's been mentioned here that multiple data files for tempdb will improve performance, even if those multiple files are all in the same location. I don't recall why,...

Curious, what company in CT ??

I think I must be doing something wrong. Here's what I did:

Create a Windows Account called "MyDomain\SQL_Proxy"

Granted SQL sysadmin permission to "MyDomain\SQL_Proxy"

EXEC master.dbo.xp_sqlagent_proxy_account N'SET', N'MyDomain', N'SQL_Proxy', N'password'

EXEC msdb.dbo.sp_set_sqlagent_properties @sysadmin_only=0

Logged on...

So I need a windows account with sysadmin rights to use as the proxy account ? Something like MYDOMAIN\SQL_Proxy, give it sysadmin permission,

then specify it in SQLAGENT properties Job...

You can put the restore and drop db scripts into individual steps in a job, then the job history will show you how long each step took. The information will...

Steve Jones - Editor (3/11/2009)

---

I'd run native backups and let BackupExec grab those files and move them off. I never found the agents to be stable enough, and even 1%...

One problem I had with BackupExec is the limited functionality when doing restores. For instance, I had a large production database, with several data files. For example Data1.mdf on the...

I use this to show me when the last Full, Diff & Log backups were (or weren't):

SELECT B.name as Database_Name,

ISNULL(STR(ABS(DATEDIFF(day, GetDate(),MAX(backup_finish_date)))), 'NEVER') as DaysSinceLastBackup,

ISNULL(Convert(char(19), MAX(backup_finish_date), 100), 'NEVER') as...

I searched the Googles and found this:

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=42175&enterthread=y