Viewing 15 posts - 256 through 270 (of 302 total)
Gail,
could yo uplz tell me how t get the management studio on node B
thanks
September 18, 2008 at 9:36 am
Thank for quick reply
I installed INS1 on Node A and INS2 on Node B. But the management studio is not installed on Node B. Iam trying to install client tools...
September 17, 2008 at 10:24 am
thanks Gails,
From Brad McGehee Article:
A 2-node active/active cluster, where you are running a single instance of SQL Server 2005 on each node. If one of the two active nodes should...
September 17, 2008 at 1:58 am
I tried the direct full backup of the failed database to \\advfuji\d$\backup. Its working fine...
According to David the job is retrying to take the full backup of failed database...
September 16, 2008 at 12:59 pm
Thank you..
This is the error I can see in the error log:
2008-09-16 03:21:20.86 spid59 BackupMedium::ReportIoError: write failure on backup device '\\advfuji\d$\Backup\AQSSQL2\CFQUTN01\CFQUTN01_09-16-2008.bak'. Operating system error 112(There is not...
September 16, 2008 at 11:36 am
To give exact picture.. There is a job running this stored procedure at every one hour between 2AM to 8PM. And initially I thought logbackup is failing but going through...
September 16, 2008 at 10:45 am
Here is the script we are using for backups.
CREATE PROCEDURE DB_BACKUP
--DECLARE
@Dbname VARCHAR(30)
AS
BEGIN
--DECLARE @Dbname VARCHAR(30)
DECLARE @RestoreString Varchar(500)
DECLARE @File VARCHAR(200)
DECLARE @File1 VARCHAR(200)
DECLARE @Device_Name VARCHAR(200)
DECLARE @FileExist INT
--SELECT @Dbname='Test'
IF NOT EXISTS...
September 16, 2008 at 9:05 am
Thanks a lot David. Here are the details in attachments
exec sp_helpdb
exec sp_readerrorlog
go
dbcc sqlperf(logspace)
Thanks
September 16, 2008 at 8:56 am
Hello David,
Iam taking the backups of server A to the 'D' drive of server B, because Server B has lots of space on it. Iam doing this from past several...
September 15, 2008 at 10:25 pm
Thanks David,
Iam using sql server 2000. The backup failed is a log backup. The job is scheduled to run every hour, at that particular time like 3:12am it failed, but...
September 15, 2008 at 5:15 pm
Thanks Adam,
I went through the link, but it did not mentioned about upgrade from evaluation edition having sp2 installed to enterprise. The RTM has no isssues,it upgraded to enterprise.
September 4, 2008 at 5:21 pm
could you please put some light on this issue:)
September 4, 2008 at 1:14 pm
can we upgrade an evaluation edition having SP2 to enterprise edition of sql server 2005?
September 4, 2008 at 9:24 am
Viewing 15 posts - 256 through 270 (of 302 total)