Viewing 15 posts - 76 through 90 (of 365 total)
We have 2 node a/p cluster set up for SQL Server 2008 R2.
The backup goes to Shared Clustred Drive. In this case, can we set up separate network card for...
March 15, 2012 at 11:30 am
We are NOT using Veritas SFW disks.
We have EMC SAN.
Thanks
March 6, 2012 at 9:08 pm
Still I'm not sure whether SQL Server 2008 R2 Filestream supports for Mount Points in cluster environment?
Please clarify me...
Thanks
March 6, 2012 at 2:31 pm
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[BackupDatabase]
@DBName VARCHAR(75),
@BackupPath VARCHAR(2000),
@BackupType VARCHAR(4) = 'FULL'
AS
BEGIN
DECLARE @BackupName VARCHAR(255)
DECLARE @Prefix VARCHAR(50)
DECLARE @backupSetId AS INT
-- Make sure database exists on server
IF NOT EXISTS (SELECT 1...
March 1, 2012 at 11:09 am
edit the job step and add a log file output for the step, we can then view this next time it fails. can you post details of the script you...
March 1, 2012 at 10:43 am
Is this native SQL Server backup, or a third party backup?
Is it local, or to a remote drive or share?
It is sql native backup.
Backups to a clustered drive.
February 29, 2012 at 12:44 pm
last Wait Type is BACKUPTHREAD.
The backup disk fine. Because all other databases backups have NO issue except one database that got hung.
February 28, 2012 at 12:29 pm
Hi Tarvin,
Ah, good ol' Litespeed. Was this is a script generated by the Litespeed console?
What exactly are you trying to accomplish with the OUTPUT variable?
I have an existing script...
January 25, 2012 at 12:59 pm
I just found the below link, which confirms the SQL Server 2008 does NOT support MountPoints with FileStream.
Is it still DOES NOT support in SQL Server 2008 R2...
January 19, 2012 at 11:33 am
Thanks azdzn.
In Oracle, from toad for Oralce, if we select a table and see the Script, it shows complte table script along with the grants
But in SSMS, I can only...
January 13, 2012 at 11:49 am
Good news..
From the above link, I understand that SQL Server 2005 Reporting services MUST be at SP2 to upgrade to SQL Server 2008 R2.
Our SQL Server reporting services...
December 15, 2011 at 11:24 am
Hi,
I have uninstalled everything and started from the scratch by following the same steps. But still having the same issue? Am I missing any steps?
I went through the link
December 14, 2011 at 11:08 am
I just ran the profiler.
When I ran a report from report manager, user abc\serverA$ is making connection to reportserver database but not abc\mssqlsrv.
Profiler output:
RowNumberEventClassTextDataApplicationNameNTUserNameLoginName
4810exec ObjectExists @Path=N'/Apps',@AuthType=1Report ServerSERVERA$ABC\SERVERA$
Is that correct? I...
November 8, 2011 at 6:11 pm
When you created the report, you had to create a data source. What is the definition of your data source that you created in SSRS for this report?
The user abc\serverA$...
November 8, 2011 at 5:16 pm
Viewing 15 posts - 76 through 90 (of 365 total)