Lowell (9/1/2010)

---

for me, the master database doesn't have anything of interest besides logins;

i would restore a master database as a user db so i could extract logins, if they...

Gail, I am confused here.

For example, from FULL BAKCUP A to FULL BACKUP B, we have a log...

What kind of issues you got from MP?

I have been using MP for at least 3years. So far so good. (Here, I mean BACKUP only, not for others maintenance jobs.)

(The...

You can use Maintenance plan.

Thanks, GSquared .

I got it figured out. Yes, it is trying to connect another server. After I modified the linked server security, the error is gone.

Cheers.

Is this what you asked for?

SELECT SUBSTRING(@name, 1, CHARINDEX('-', @name) -1)

OR

SELECT LEFT(@name, CHARINDEX('-', @name) -1)

1st, using the following script to move model and msdb to destination:

--- Moving msdb

alter database msdb modify file (name = MSDBData, filename = 'X:\MSSQL\DATA\MSDBData.mdf')

go

alter database msdb modify file (name =...

Error log should have an entry for DBCC FREE...CACHE

When you say this is the Production Support team, what exactly do you mean? Are they DBA's or System Admins? If they are only system admins and shouldn't be able...

SQL Server 2008 SP2 is out!

http://blogs.technet.com/b/dataplatforminsider/archive/2010/09/29/sql-server-2008-sp2-is-available-for-download-today.aspx

Since your 'HEAP' table has 57GB on disk, your 'Cluster indexed' table should have almost the same size on the disk.

Yes, you can.

Not sure what you asked.

There are several _history tables in distribution db, like, MSdistribution_history, MSlogreader_history, etc......

1. Make the remote folder shared, and make sure the SQL Server Agent has write-permission on that folder. (Maint plan can't see the remote shared folder. You have to input...

I...