• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

SQL 2005 Issue/Question

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
Leathal
Just Arrived
Just Arrived


Joined: 14 Nov 2004
Posts: 0


Offline

PostPosted: Wed Feb 18, 2009 4:56 pm    Post subject: SQL 2005 Issue/Question Reply with quote

We have two Dell PowerEdge 6950's wit 4 x AMD dual core 2.8Ghz CPUs, 16GB of RAM, 4 x 146GB 15k SAS HD (RAID 10) and a PCI-X Intel dual Gbit NIC.

The servers run Windows 2003 Server Stnd Ed x64 along with SQL 2005 Server Stnd Ed x64.

The NIC on both servers are setup in teaming as Active/Passive, Auto Detect, and are connected to two Dell 2716 web managed switches (10/100/1000Mbit) one for each cable on the NIC.

The databases are setup in a Mirror & Witness configuration with a 3rd machine (HP DL145 G2) acting as the witness.

We started this when our DB wasn't very large, the backups were only taking up about 1.5 to 2GB; back then we used gzip. Now that DB backups are growing at an alarming rate, currently it's almost 12GB compressed/85GB uncompressed, we are experiencing I/O issues between the mirror and backup, as well as timing issues between the DB and any of the 7 application servers.

Our DBA guy keeps asking me to find out why there is an issue with the I/O and that I should check to see if one of the drives is bad. The drives are fine and don't report any issues I am wondering now since the DB has grown so big in the past year if it's really starting to stress the hardware?

Any suggestions?
Thanks
Andrew
Back to top
View user's profile Send private message
Leathal
Just Arrived
Just Arrived


Joined: 14 Nov 2004
Posts: 0


Offline

PostPosted: Mon Feb 23, 2009 7:00 pm    Post subject: Reply with quote

bumb
Back to top
View user's profile Send private message
alairauston
Just Arrived
Just Arrived


Joined: 03 Jul 2010
Posts: 0
Location: lklkl

Offline

PostPosted: Wed Jul 07, 2010 8:14 am    Post subject: Reply with quote

When I try to install a new instance of SQL Server 2008 Express on a development machine with SQL 2005 Express already up and running, the install validation fails because the "SQL 2005 Express tools" are installed and I'm told to remove them.SQL stored procedure which generates a single table. The records are linked together via a parent/child relationship (ID and ParentID), and we use this table to populate the treeview.
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger MSN Messenger
veerji
Just Arrived
Just Arrived


Joined: 27 Sep 2012
Posts: 1
Location: 38000

Offline

PostPosted: Thu Sep 27, 2012 8:29 am    Post subject: Nice Reply with quote

I have a dedicated server which I use for clients, it got hacked a few months back via some little **** using an SQL injection attack on a site we had taken over from another company , stupidly we had not gone through and checked the code.
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Looking for more Windows Networking info?

Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing!
View a sample newsletter.

Become a WindowsNetworking.com member!

Discuss your Windows Networking issues with thousands of other Windows Newtorking experts. Click here to join!

Community Area

Log in | Register

Readers' Choice

Which is your preferred data recovery solution?

Follow TechGenix on Twitter