Forum Replies Created

Viewing 15 posts - 256 through 270 (of 302 total)

  • RE: Active/Active cluster setup in s2k5

    Gail,

    could yo uplz tell me how t get the management studio on node B

    thanks

  • RE: Active/Active cluster setup in s2k5

    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...

  • RE: Active/Active cluster setup in s2k5

    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...

  • RE: backup failed

    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...

  • RE: backup failed

    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...

  • RE: backup failed

    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...

  • RE: backup failed

    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...

  • RE: backup failed

    Thanks a lot David. Here are the details in attachments

    exec sp_helpdb

    exec sp_readerrorlog

    go

    dbcc sqlperf(logspace)

    Thanks

  • RE: backup failed

    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...

  • RE: backup failed

    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...

  • RE: backup failed

    The size of the database 14gb.

  • RE: Upgrade enterprise evaluation to enterprise edition

    Thank you:)

  • RE: Upgrade enterprise evaluation to enterprise edition

    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.

  • RE: Upgrade enterprise evaluation to enterprise edition

    could you please put some light on this issue:)

  • RE: Upgrade enterprise evaluation to enterprise edition

    can we upgrade an evaluation edition having SP2 to enterprise edition of sql server 2005?

Viewing 15 posts - 256 through 270 (of 302 total)