Your database user ID's no longer match your server login ID's, this is known as an orphaned user. In the case of a sysadmin, you shouldn't have that problem though...

Cory Ellingson (3/6/2008)

---

The biggest issue I had was with linked servers from the 64bit to 32 bit SQL servers. I had to run an update on all the 32...

What service pack/revision are you on?

SELECT SERVERPROPERTY('ProductLevel')

SELECT SERVERPROPERTY('ProductVersion')

While I don't know exactly what those errors are eluding to, there is a good chance you can resolve this with an update....

The_sponge (3/6/2008)

---

Its not you, Its definately above mine

Ive had a look , theres no blocking but the spid is suspended with a wait type of ASYNC_IO_COMPLETION

on the top row,BACKUPBUFFER in...

Is it me or did my post end up above yours?

That is the agent logs (the scheduler), you want to look at the error logs for SQL server.

SSMS - Management -> SQL Server Logs

or

sp_readerrorlog

or

Install Location\Microsoft SQL Server\MSSQL.InstanceInstallNumber\MSSQL\LOG

3+ hours for a 40GB backup? Is your NIC 100mb or 1GB? Regardless, that is out of control ... sounds like you may be experiencing some blocking. I assume you're...

I don't use maintenance plans much ... but it looks like whatever your step is doing, need to bracket the table names as they have spaces ...

[from msx]

[has targets]

What is it exactly you're attempting to do?

SELECT * FROM msdb.dbo.sysjobs

SELECT * FROM msdb.dbo.sysjobhistory

All your information is in those two tables ... join the job_id's and you're good to go.

It will update stats, but not with FULLSCAN ...

sp_readerrorlog

Check out what happened ...

Karthika Raman (3/5/2008)

---

We have run the upgrade Advisor and working with the vendor that provides the application to resolve any issues that need to be addressed.

One more question - this...

Paul Randal (2/26/2008)

---

That would be a bit useful if they were on SS2000, but they're not. Please check which forum you're in before posting inappropriate links...

Something to note (I'd go look for white pages on this to confirm), but I do not believe you can restore the master db in 2005 anymore with the dependency...

That's an odd one and I'd really like to hear more on this as I've been using DTS in 2005 quite regurarly without any problem. The fact that loading the...