Cough, cough...... :pinch:

Just reread the whole post again. the error is in the create view.

Check constraint for invoice 13453 is in DB 2013, but that's not included in the...

Hi,

Windows search on *.bak.

Goodluck.

Oops! :blush:

Thanks Sean!

Haven't used it in many years.

Maybe an obvious question, but have you tried rebooting node1?

Unfortunately the link doesn't work for me.

Goodluck.

Hi,

This code helps me keep track of what's being backed up, and more importantly, what is not.

You'll need a DB and table to store the data in.

ALTER PROCEDURE [dbo].[usp_GetSvrDBBackups] @Svr...

I have been trying to recreate this, thinking it was a bug. Looks like it isn't.

This test DOES work.

-- Create test tables

CREATE TABLE Invoicing_2004..T1 (Val Int PRIMARY KEY)

CREATE TABLE...

Hi,

Thanks for responding.

The code is preety straight forward.

CREATE VIEW InvoiceData

AS

SELECT *

FROM Invoicing_IVS..InvoiceData_Actual

UNION ALL

SELECT *

FROM...

Hi,

Sorry don't know too much about this yet. But here are a couple of links i'm reading at the moment about this....

http://msdn.microsoft.com/en-us/library/bb934049%28v=sql.105%29.aspx

http://msdn.microsoft.com/en-us/library/bb895327%28v=sql.105%29.aspx

Hope this helps.

Goodluck.

Hi,

Before inserting the data, find out what the MAX(LEN(Col)) is for each column. Compare the results to your variable declarations and destination table design.

Btw, varchar(max) isn't recognized in SQL...

Hi,

Maybe it's an idea to find out WHO are creating all these objects and why. Could be that they need their own test environment. Even if you find a...

Hi,

Try checking all logins you are using throughout the whole process, including all services accounts.

In the jobs list, take a look at the history. Maybe that will give more idea...

Hi,

It's not clear what your issues is.

If your cluster isn't allocating resources correctly then I don't think you are posting in the right place.

Make sure your cluster is working properly....

If you have access to SSMS 2008 you can right click on the instance name and select Activity Monitor.

This will give you a good place to start troubleshooting.

Make sure no other instances of SSMS are open.

If you have multiple tabs open, make sure they are not pointing to the DB in question.

You could also try restarting the...

Hi,

Just was reading about this. I think you should take a look at these posts for a more in depth explanation and comparison.

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/435aa6ea-9db3-4415-95d0-68c2ae1fbe16

http://archive09.linux.com/feature/142658

http://www.novicksoftware.com/Articles/sql-server-ssd-solid-state-disk.htm

Looks like it's becoming quite common to use...