Search Results | SQL Server Performance Forums

SQL Backup

Post by: mcosy, Jun 11, 2008 in forum: Getting Started

HI All, Bit confuse and please help to setup correct way of backup. I got SQL Server 2000 and Veritas Backupexec 12.0 SQL agent So what is...

SQL Backup

Thread by: mcosy, Jun 10, 2008, 3 replies, in forum: Getting Started

Hi, what is your recommended way to backup SQL Servers. 1. Veritas Backup agent? 2. SQL MP to create bak file and transaction logs? 3. Use...

Veritas sql backup

Post by: mcosy, Jun 3, 2008 in forum: General DBA Questions

can someone help pls?

Veritas sql backup

Post by: mcosy, May 29, 2008 in forum: General DBA Questions

HI , Thanks, So what is your recommended way to backup SQL Servers. 1. Veritas Backup with Differtial (Mon-Thu) and full backup on Friday?...

Veritas sql backup

Post by: mcosy, May 29, 2008 in forum: General DBA Questions

Can you explain that please.

Veritas sql backup

Post by: mcosy, May 29, 2008 in forum: General DBA Questions

HI, You only use Veritas to backup SQL.bak file generate through your MP? and not using Veritas SQL backup software to backup databases? if so why...

DBAudit

Thread by: mcosy, May 22, 2008, 1 replies, in forum: General DBA Questions

HI All, Is there way to enable us tochoose certain tables/fields to monitor changes on our SQL 2000 Server or do we need to buy this dbaudit...

Disadvantage of this Config

Post by: mcosy, Apr 7, 2008 in forum: Performance Tuning for Hardware Configurations

HI, Thanks, But According to Joe Chang articles distributing IO load over as many spindles (diskdrives) and IO channels is the way to get more...

Disadvantage of this Config

Thread by: mcosy, Apr 3, 2008, 3 replies, in forum: Performance Tuning for Hardware Configurations

HI All, Please tell me the disadvantage of this following config for SQL server. Controller 1 : OS : RAID 1 : 2 x 72GB Controller 2 : LOG :...

New Hardware For SQL Server

Post by: mcosy, Mar 25, 2008 in forum: Performance Tuning for Hardware Configurations

HI, Thanks, But where do i put LDF files? with Data files?

New Hardware For SQL Server

Post by: mcosy, Mar 12, 2008 in forum: Performance Tuning for Hardware Configurations

HI Thanks Guys, One more thing to sort out and just bit confuse with transaction logs and sql log ( *.LDF) where we put those 2 types of logs in...

New Hardware For SQL Server

Post by: mcosy, Mar 6, 2008 in forum: Performance Tuning for Hardware Configurations

the performance is better with larger capacity?

SQL Server 2000 is much slower on Windows 2003 than Windows 2000. Any help?

Post by: mcosy, Mar 5, 2008 in forum: Performance Tuning for DBAs

Hi, I think running on 64Bit Windows 2003 OS can use more Meomory and will help SQL 32 bit even with 2GB limitation?

New Hardware For SQL Server

Post by: mcosy, Mar 5, 2008 in forum: Performance Tuning for Hardware Configurations

HI, I think IBM and HP both support is OK. But is there any big performace with above two system ? attaching external storage for data? How abt...

New Hardware For SQL Server

Post by: mcosy, Mar 2, 2008 in forum: Performance Tuning for Hardware Configurations

Hi, No help so far?????

New Hardware For SQL Server

Post by: mcosy, Feb 20, 2008 in forum: Performance Tuning for Hardware Configurations

Hi As per JO best configuration as follows. But just confuse with transaction logs and sql log ( *.LDF) where we put those 2 types of logs in this...

New Hardware For SQL Server

Post by: mcosy, Feb 4, 2008 in forum: Performance Tuning for Hardware Configurations

HI, Thanks, But without external Storage? happy to spend upto 30-40K

New Hardware For SQL Server

Thread by: mcosy, Jan 30, 2008, 14 replies, in forum: Performance Tuning for Hardware Configurations

HI All, I'm trying setup new Sql 2000 Server and can you recomend the hardware. Think of Windows 2003 64bit OS with 32 bit SQL 2000 ( NO for SQL...

SQL Disaster recovery Solution

Thread by: mcosy, Nov 12, 2007, 5 replies, in forum: SQL Server 2005 Performance Tuning for Hardware

Hi All, I got 1 SQL Server and got DA storage. So what are the solution for disaster recovery?

New SQL Server Hardware Configuration

Thread by: mcosy, Sep 20, 2007, 2 replies, in forum: Performance Tuning for Hardware Configurations

HI Guys, Finally i'm going to buy this new Server and SAN for my company but got few questions and please advise 1. DS3400 can hold 12 HDD so can...