GSquared, your solution is not quite the same as the original unions. With the unions - if modifier1 and modifier2 both have values - and those values are different...

Instead of viewing the job history, you need to look at the maintenance plan history. Right-click on the maintenance plan in Object Explorer and view history.

Find the step that...

pavan_srirangam (11/1/2010)

---

This is all when your log file is growing every day and causing issues you have to go through this process

But kimberly says you have to set it single...

This sounds very reasonable to me. With the increased size of the auto-growth, even if it grows out to 4GB again you won't have too many VLF's. Well,...

It didn't happen by itself. It happened when log shipping was set up and the database was restored on that system.

You can't change it now without rebuilding log shipping....

Hi Scott,

You can see several examples of queries with inner joins and outer joins in the AdventureWorks database itself. Open the Views folder and take a look at the...

It's possible that the person who set this up created the data files using .BAK as the extension. You can validate what files are being used by:

SELECT * FROM...

hydbadrose (10/27/2010)

---

Ok- let's make it simple. When I login to node b (xyzdb01b) and in configuration manager/services all I can see is named instance service not MSSQLSERVER services. And when...

Brad, please start a new topic for this request. This is a very old thread and you'll get many more people looking at your issue if you start a...

I am not clear on how you are trying to access the 'default' instance. What are you using to 'see' the instances on each node?

When you fail the 'default'...

How are you determining that node b is missing SQL Server?

Are you able to failover the 'default' instance on node A to node B?

Are you running SQL Server on x64 hardware?

Are you running an x64 version of SQL Server?

If so, have you set the max memory for all instances on that system?

If not,...

On a side note - since you are on SQL Server 2008 you can implement a policy that prevents database names from having spaces - or any other special characters...

When you install SQL Server on a cluster, the installer will install the across all nodes. The instance will then be active on only one of those nodes. ...

Yes, you should always update the client tools to the highest version level (at least) of any systems you access.

So, if you access a server with SP3 installed - you...