Administration

• Topics

  Started by

  Posts

  Last post

• Why moving a database slowed it down a lot?

  Hello, We have recently moved a database to Amazon EC2 instance. We chose the server with identica…

  sql_er

  29 replies

  15 years, 11 months ago

  By: tosscrosby

• Add standard text to all stored procedures

  Hi, Been struggling with this one for a day or two. As part of our migration and upgrade project (…

  Fishbarnriots

  11 replies

  15 years, 11 months ago

  By: Fishbarnriots

• How to add more space in Unallocated space?

  sp_spaceused return values after running dbcc updateusage. here i am think space issue in database.…

  SQL Galaxy

  1 replies

  15 years, 11 months ago

  By: MANU-J.

• SQLMail

  All I am having a few issues with SQLMail since Saturday before it was working as expected. Using x…

  Ant-Green

  3 replies

  15 years, 11 months ago

  By: MANU-J.

• Server becomes slow(dead) when RAM Utilisation is more than 4 GB

  Hi, In our client Place Server configuration is 16 GB RAM, 160 GB Hard Disk. OS Windows 2003 server…

  ComITSolutions

  5 replies

  15 years, 11 months ago

  By: EdVassie

• Log growing Unpredictably

  Hi All, I have a problem with one of my database; while updating a table contains oddly 50,000 rows…

  madhav.bms

  4 replies

  15 years, 11 months ago

  By: madhav.bms

• data file -Unrestricted option

  HD size is total 653 gb, There are two data file as 1. fdcrt_data size is (124216), 2. fdcrt_1_Da…

  SQL Galaxy

  2 replies

  15 years, 11 months ago

  By: U J

• Copy A Database into Different Server

  Hi - I might be posting a post that been posted here before but somehow I couldn't find my answer. …

  keyun

  2 replies

  15 years, 11 months ago

  By: keyun

• Linked Server Troubles

  I getting one of microsoft's usefull errors and I am not sure how to resolve it. If you have a good…

  Shawn McClory

  8 replies

  15 years, 11 months ago

  By: SQLBalls

• datafile freespace issues

  Database size is 289385.75 MB. One of the production server have database free space issues, user …

  SQL Galaxy

  1 replies

  15 years, 12 months ago

  By: Bru Medishetty

• Too Many Databases

  I've got a SQL 2000 server with 39 user databases on, probably 34 are live, how do you know when th…

  Buxton69-502449

  7 replies

  15 years, 12 months ago

  By: Gail Shaw

• DB Backup file copy error

  We have a prod and a test Win2003 servers running SQL 2000 SP4. I backup the prod db to the local …

  Anonymous

  7 replies

  15 years, 12 months ago

  By: Anonymous

• DBCC shrink file error

  Trying to shrink a database file (the mdf, NOT the log file) and after a while I got the following …

  sql-lover

  5 replies

  15 years, 12 months ago

  By: MANU-J.

• Having to run this dbcc command to free up system ?

  Hi All, I sometimes tend to get slow degrading performance on billing prod server, but on running d…

  Dean Jones-454305

  11 replies

  15 years, 12 months ago

  By: Gail Shaw

• SQL Mail

  I am trying to set up,do I need to set up seperate sql account to run sql mail

  Krasavita

  6 replies

  15 years, 12 months ago

  By: Lynn Pettis