In configuration manager, under the SQL Server 2005 services you should have a service for instance of SQL

SQL Server (MSSQLSERVER) -- Default

SQL Server (Name of Instance1) -- Named insatnce 1

SQL...

The script below shows how to grant select permissions to a specific table.

I create a login called test.

--Creates a login

USE [master]

GO

CREATE LOGIN [Test] WITH PASSWORD='P@ssw0rd'

GO

I then create a user in...

If you have no access to the remote server, how are you going to access it using BCP?

Just to add to Jason's post, we use Legato to backup our SQL Backups (Redgate Backups to disk) and we mirror log backups to another server but also backup...

You don't have a schdule setup on those jobs that says "Run on Agent startup"?

Which would obviously run the jobs specified.

This link might help you:

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

Surely a cluster failover will be relatively transparent to your users?

Are the application using it cluster aware?

I'll second that.

The_SQL_DBA (1/7/2010)

---

Oksana March (1/7/2010)

---

Bru Medishetty (1/7/2010)

---

The_SQL_DBA (1/7/2010)

---

Bru Medishetty (1/7/2010)

---

You can start creating...

AdammadA (1/7/2010)

---

Yeah... it sorta makes sense.

I guess my problem is that why would it even...

That would make sense, you can't backup the log of the database in simple mode.

OK what is the maint plan trying to do?

Is the maint plan doing what you want?

How often is the job scheduled to run?

AdammadA (1/7/2010)

---

I've had some issues recently with jobs created from a maintenance plan reported as successful even if the maintenance plan failed.

Has anyone seen this behavior? Any thoughts on...

Note sure if this is the same link but may also help you:

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

Borrowing Steve's query the below will return DB name and create date

exec sp_msforeachdb 'select ''?'', create_date FROM sys.objects where name = ''sysrowsets'''