SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Shrining log file not releasing the unused space

  I have a database with almost 116 GB of log file size. Earlier it was showing the available free sp…

  viduvs

  10 replies

  3 years, 10 months ago

  By: Perry Whittle

• SQL Server service is not stopping

  There was a bottleneck in a server. In order to avoid that I have changed some configuration change…

  Knowledge Hunter

  7 replies

  3 years, 11 months ago

  By: ekbordo

• Restoring Database from Snapshot on the different Server

  Hi, I am a SQL DBA in our Company. I found lately that the Database Snapshots can be very useful fo…

  AER

  9 replies

  4 years, 3 months ago

  By: joe-676144

• Attempted to perform an unauthorized operation

  Hi, I'm installing SQL Server 2008 x64 developer edition on Windows Server 2008 x64. I installed th…

  Mani-584606

  6 replies

  4 years, 5 months ago

  By: mohammadsj

• Full and Differential backup size is same ??.

  Hi, Sub:Full and differential backup size same. I am facing the following problem on production ser…

  abdul.samad.121

  16 replies

  4 years, 5 months ago

  By: Grant Fritchey

• DB Randomly sets in Single User Mode

  I have a database that on at least 2 occasions randomly went into single user mode. It was not imme…

  riggins13

  7 replies

  4 years, 8 months ago

  By: equipe9

• Log shipping and CDC

  I come seeking the wisdom of the collective. I have searched to no avail to try and understand the …

  Ells

  2 replies

  4 years, 9 months ago

  By: Chad Franklin

• SQL Agent job ownership - allowing multiple users to edit a job

  Challenge We do not want every user who manages Agent jobs to have the fixed SQL Server agent role,…

  johnzabroski

  14 replies

  4 years, 9 months ago

  By: SQLRocker

• Default Server Collation for SQL - does it depend on the O/S version (standard vs. enterprise)?!

  I'm having the following predicament. I recently installed SQL 2008 SP1 on 2 servers; in both insta…

  Marios Philippopoulos

  15 replies

  4 years, 10 months ago

  By: Perry Whittle

• Merge Replication problem after table deletions

  Hi Overnight we deleted 4 million rows out of on table on the subscriber database with merge replic…

  alex.palmer

  1 replies

  4 years, 11 months ago

  By: alex.palmer

• SQL Server 2008 Hang and not responding

  Recently my sql server hang quite often. When my sql server hang, i tried to connect to sql server …

  pi_goh

  6 replies

  4 years, 11 months ago

  By: pi_goh

• Upgrading to SQL Server 2014 R2 (SSRS related)

  Tomorrow I plan to do an in place upgrade of a SQL Server (standard) 2008R2 instance to 2014 R2. Am…

  Jay@Work

  1 replies

  5 years ago

  By: Grant Fritchey

• Database Mail Queue stuck in INACTIVE State - can't get Database Mail to work on Server

  Please post to the following: http://www.sqlservercentral.com/Forums/Topic1276632-1550-4.aspx#bm127…

  Welsh Corgi

  13 replies

  5 years, 1 month ago

  By: chuck kruelle-156702

• Restore SQL 2005 dbs to 2008

  Hello all, I had a crashed server which i needed to build from scratch, after building , i used SQL…

  XP2600

  1 replies

  5 years, 2 months ago

  By: MVDBA (Mike Vessey)

• Restore SQL 2005 dbs to 2008

  Hello all, I had a system running SQL server 2005, after a crash i needed to build the server from …

  XP2600

  5 replies

  5 years, 2 months ago

  By: Ant-Green