Search Results | SQL Server Performance Forums

How to restore missing data on SQL 2005?

Thread by: shawn, Jan 30, 2012, 1 replies, in forum: ALL SQL SERVER QUESTIONS

Hi, This is my situation for databse on SQL 2005 and Windows 2003: - Application use database1 - database1 on SeverA is replicated on database1 of...

How to test a SQL connection from Windows 2008?

Post by: shawn, May 25, 2010 in forum: SQL Server 2005 General DBA Questions

After many tests, I realized that the prob is due to firewall. I disabled it and the application can communicate with the SQL server. Thank you for...

How to test a SQL connection from Windows 2008?

Thread by: shawn, May 20, 2010, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I have an application on IIS (Windows 2008) which communicate to a database on MS SQL 2005 (Winows 2003). How could I test the connection...

For good performance of SQL 2005 how the server disks should be mounted in Windows 2003?

Post by: shawn, Apr 23, 2010 in forum: SQL Server 2005 Performance Tuning for Hardware

Thank you Satya for your advises, What do you of this setting?: RAID1: one partition C: for Windows, sec partition D: for SQL Logs RAID5: One...

For good performance of SQL 2005 how the server disks should be mounted in Windows 2003?

Thread by: shawn, Apr 21, 2010, 2 replies, in forum: SQL Server 2005 Performance Tuning for Hardware

For good performance of MS SQL 2005 how the server disks should be mounted in Windows 2003 or 2008? What do you think of this: 2 disk in RAID1 for...

Does a full backup will help to decrease the size of the log file?

Post by: shawn, Feb 9, 2010 in forum: SQL Server 2005 General DBA Questions

Ok I see. Thank you all of you for all your advices.

Does a full backup will help to decrease the size of the log file?

Thread by: shawn, Feb 8, 2010, 8 replies, in forum: SQL Server 2005 General DBA Questions

Does a full backup will help to decrease the size of the log file in MS SQL 2005?

MS SQL 2005 backup extension: .bak,. trn, .full

Post by: shawn, Feb 2, 2010 in forum: Getting Started

Thank you for the explanations, that confirm what I thought.

MS SQL 2005 backup extension: .bak,. trn, .full

Thread by: shawn, Feb 1, 2010, 2 replies, in forum: Getting Started

I have a simple question, sometime I see different extensions on MS SQL 2005 backup like : bak,. trn, .full What is the difference between them?...

How security is set on drives of Windows Server 2003 to let only specific SQL Server Instance acces to them?

Post by: shawn, Dec 17, 2009 in forum: Getting Started

Your are right Elisabeth...the SQL servers are set in cluster mode..so the drives are shared by the ressources in windows cluster manager... I forgot...

How security is set on drives of Windows Server 2003 to let only specific SQL Server Instance acces to them?

Thread by: shawn, Dec 17, 2009, 3 replies, in forum: Getting Started

How security is set on drives of Windows Server 2003 to let only specific SQL Server Instance acces to them? For exemple: - Windows 2003A, has SQL...