SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• SQL SCript for Backup Compression

  hi, i am planing to implemnet new backup plan for my databases with compression. can any one share …

  Diyas

  7 replies

  2 weeks, 6 days ago

  By: Srinivas Merugu

• Adding data & index file best pratices?

  Hi, For adding data file & index file on default primary file group Currently datafile.MDF siz…

  SQL Galaxy

  9 replies

  7 months ago

  By: jvargas

• Replication Error: 14151, severity: 18, State 1.

  Hi, I have like a orphaned publisher trying to push out a transactional request or something. I ca…

  JP10

  4 replies

  7 months, 1 week ago

  By: sqlServerCentralUsers123

• Job History "Initialize Log #1... #50"

  As part of my daily sql 2008 tasks I review the job history from last night's run. When the log Fil…

  Barkingdog

  1 replies

  10 months, 2 weeks ago

  By: r5d4

• Login failure for user 'NT AUTHORITY\ANONYMOUS LOGON'

  Would someone help with error message that a developer kept getting when editing some custom made s…

  rjoseph

  7 replies

  1 year, 5 months ago

  By: Ant-Green

• How to check if the column is replicated? (sys.columns..is_replicated is misleading)

  I have a column-level transactional replication. Usually, I use the following query to check if a c…

  ravi lobo

  1 replies

  1 year, 9 months ago

  By: sir.kiiski

• View any database option

  How can i make sure any login on the server can view only the database that they have access to. I …

  Tara-1044200

  3 replies

  1 year, 12 months ago

  By: Ken McKelvey

• How to restore a database with Full Text Search

  HI, The SQL Server instance is 2008 R2. I have a database with a Full Recovery Model and Full Text …

  mpdillon

  11 replies

  2 years, 7 months ago

  By: Johan Bijnens

• how to Make a copy of Full Recovery DB and Restore it to a Simple Recovery Db

  Hi, If this post is not in the correct forum, please let me know which forum it should be in and I …

  mpdillon

  7 replies

  2 years, 7 months ago

  By: Jeff Moden

• Very slow db detach

  I was recently trying to detach a database using: ALTER DATABASE MyDatabase SET SINGLE_USER WITH RO…

  chris4600

  8 replies

  2 years, 7 months ago

  By: Jeff Moden

• Change location of FDLaunchErrorLog

  I've relocated my system databases to a new drive and I want to decomission the old drive, however,…

  Josh B

  1 replies

  2 years, 12 months ago

  By: ejanakieff.informatica

• one job most of time runs successfully, but somtimes failed

  My OS is Windows server 2008 R2 enterprise, and SQL Server is 2008 R2 standard edition,  I created…

  892717952

  1 replies

  3 years, 4 months ago

  By: Grant Fritchey

• system runs slowly, but SQL server can't use the RAM over 74GB?

  My OS is windows server 2008 R2 Enterprise, SQL Serer is 2008 R2 Standard edition, the installed is…

  892717952

  5 replies

  3 years, 4 months ago

  By: Grant Fritchey

• SQL Server appcrash PISDK.dll

  Hi, all! Today I got this error on my production system: Faulting application name: sqlservr.exe, v…

  fahrenheit635

  1 replies

  3 years, 6 months ago

  By: fahrenheit635

• SQL Server appcrash PISDK.dll

  Hi, all! Today I got this error on my production system: Faulting application name: sqlservr.exe, v…

  fahrenheit635

  1 replies

  3 years, 6 months ago

  By: Mr. Brian Gale