Viewing 15 posts - 61 through 75 (of 173 total)
ps (7/29/2009)
query the backupfile table in msdb database and see physical_name column if it gives the backup destination(not sure)... i cant test it right now coz of some issues....
There is...
July 29, 2009 at 1:44 pm
Hi Isaballe,
Based on the error that you have mentioned, one of the transaction log backup might have got corrupted in between while transaction log backup is happening could be due...
July 29, 2009 at 8:58 am
You can do the following.
How many drives do you have on your DR Server? What is the free space available on each drive
What is the status of the database...
July 6, 2009 at 7:20 pm
winslet (7/6/2009)
as the database will be in ReadOnly mode.... It will be like a dummy login, though its same in DB...
July 6, 2009 at 5:45 am
John Doe (7/2/2009)
murthykalyani (7/2/2009)
If it is a SQL Server then we have to monitor and report the numbers to Server \ System admin team if the number are above threshold.
What...
July 2, 2009 at 1:18 pm
If it is a SQL Server then we have to monitor and report the numbers to Server \ System admin team if the number are above threshold.
July 2, 2009 at 11:24 am
C:\>
C:\>sqlcmd -SMAHESH$SQL_02 -E
HResult 0x35, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [53].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while...
July 2, 2009 at 9:26 am
mahesh.vsp (7/2/2009)
Here is my machine details:But how would these help me in fixing the above error??????????
select @@servername
-- output : MAHESH\SQL_01
select serverproperty('instancename')
-- output : SQL_01
Trying connecting with sqlcmd using this...
July 2, 2009 at 6:02 am
What is the machine name and what is the sql server instance name?
To get SQL Server Instance name please exeucte the following
select serverproperty('InstanceName')
I think you know how to get...
July 2, 2009 at 5:41 am
How many instances do you have, if you have more than 1, then you have to do it for that also.
July 1, 2009 at 6:19 pm
mahesh.vsp (7/1/2009)
Small clarification needed on Recovery Models.
As per my knowledge, If we choose Simple recovery model, we cannot take
Transaction Log backup. Right! and the reason for this whenever...
July 1, 2009 at 5:42 pm
mahesh.vsp (7/1/2009)
After connecting to the instance, as a user/ developer can i know in which mode my SQL Server is running (i.e MULTI_USER mode or Single user mode). Is...
July 1, 2009 at 5:01 pm
First, native compression is only available in SQL Server 2008 Enterprise Edition. If you are using Standard or less, you still need a third-party solution.
Lynn is absolutely correct and...
July 1, 2009 at 3:49 pm
george sibbald (7/1/2009)
apologies for asking this on a Redgate sponsored site but, ahem, would any current users of Hyperbac out there care to share their experiences?.
Backup compression with Hyperbac is...
July 1, 2009 at 3:17 pm
Viewing 15 posts - 61 through 75 (of 173 total)