You can't backup a database while it's restoring.

Watch out for apps backing up their own databases. They may be useful for places that don't have a DBA to look after things properly but otherwise get in...

Alan (8/5/2008)

---

Are you running SP2? I found maintenance plans almost unworkable until then.

I have mostly given up on the maintenance plans as they do not seems as stable as...

You will need to do this on the mirror server:

[font="Courier New"]ALTER DATABASE DBName SET PARTNER FAILOVER WITH FORCE_SERVICE_ALLOW_DATA_LOSS[/font]

Since the mirror server can no longer see the primary server and negotiate...

Some good answers coming out here, stuff I'd never have thought of.

My response would have been: "I need to do my own audit of the systems they have, find...

Having read through the comments, it can be all summed up in the usual two words that apply when someone asks if something can/is best done in a particular way:...

Where are you copying the data to/from? Does the SQL Server Agent account have rights to those folders?

Then you have posted in the wrong forum. You should have posted here:

http://www.sqlservercentral.com/Forums/Forum5-1.aspx

I would look at the SPN, as mentioned...

What OS is on the client? Is there a firewall enabled?

Can you ping the SQL server by name and IP address?

Can you use SQLPing to see the SQL server...

Have you successfully setup other machines in the past?

Are you trying to use Windows Authentication or SQL Authentication?

Run the following command from a query window:

[font="Courier New"]SELECT * FROM ::fn_trace_getinfo(0)[/font]

This will return details for all traces running on your system. Search in Books Online for fn_trace_getinfo for...

This was one of the reasons I gave up on using SSIS for maintenance plans and rolled my own using basic T-SQL. I found SSIS just added an unnecessary...

Assuming you are running this query on the SQL Server itself, try this (substitute dbname.schema with whatever database & schema the table is in):

[font="Courier New"]SELECT @output ='bcp "select * from...

That error indicates that an attempt was made to mount a log file as a data file (which is never going to work). Seems to be some sort of...

I haven't done Active/Active clusters but I have done 2 node Active/Passive with no problems. Reboot passive node, failover when done, reboot other node.

At what point does the node...