Hi ALZDBA,

I'm able to resolve the backup file NOT to append to the existing files even if it crosses 12:00am by changing CONVERT(VARCHAR(50), GETDATE(),110) to CONVERT(VARCHAR(50), GETDATE(),120)

IF @BackupType = 'FULL'

...

Yes.

And I do not...

The data source is Oracle and the query is finishing in 15 mins at oracle end.

But the report rendering is taking hours and it's not showing up any results and...

The above script is running fine in sql 2005. But in sql server 2008 R2, some times, it's performing integrity check for all databases and some times performing index defrag...

yes, user has the access. He is able to run all other reports except this.

The dbo.execution log table shows that the report was finished in 10 mins but the actual...

I went through the below link and I'm clear that FileStream cannot have Multiple Files in a FileStream Filegroup.

But, I'm not sure whether we can have Multiple Filegroups for Filestream?...

Thanks Gail,

I do have one more question and I hope you can clarify that.

I have configured FileStream as below.

Use Mydb

go

if not exists (select groupname from sysfilegroups where groupname=N'RBSFileStream')

Alter database...

The storage is SAN.

So that means we can not use Powershell 2.0 for SQL Server 2005 on Windows 2003 servers?

What are the sanp-ins we need add for SQL Server 2005?

The way we add...

I already tried [string] $toAddress="user1@abc.com;user2@abc.com". But getting the below error: (In Powershell, I know that, we should use comma but do not know how to use it)

Send-MailMessage : The specified...

I got it.

$mydate= get-date.Adddays(1)

Thanks

Is it possible to configure the SQL Server 2008 R2 cluster on in such way that, node1 resources can only failover to node2 and node3 resources can only fail...

I'm also in same scenario and confused with the ADD NODE operation on 3 nodes.

please advice

Thank you,

We just created Single node Windows 2008 cluster and according our Windows admin, we...

Thank you,

Could you please provide me the screen shot where the...