SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Migrating to new SAN and DBCC SHRINKFILE

  We currently have about 1500 GB in data files on one SAN and need to move to a new (and hopefully b…

  n.heyen

  2 replies

  13 years, 10 months ago

  By: n.heyen

• Disabled jobs still running and stranger things

  Hi. I've got an SQL Job on an Microsoft SQL Server 2008 R2 (SP1) install. It was failing and we wer…

  giles.clapham

  1 replies

  13 years, 10 months ago

  By: giles.clapham

• Sql server memory allocation

  Hi All, I am sql developer and recently I got a server for administration, but that was build by an…

  snsingh

  1 replies

  13 years, 10 months ago

  By: Gail Shaw

• Where to declare a data type when a function's parameters are declared

  For readability is it preferable to declare variables an their data type outside and before the fun…

  Golfer22

  4 replies

  13 years, 10 months ago

  By: Gail Shaw

• Steps to consider at time of testers working on database

  Hello, Can someone provide me set of instructions to consider at the time when testers works…

  DBA_Learner

  7 replies

  13 years, 10 months ago

  By: DBA_Learner

• Encryption in SQL 2008 Standard Edition 64 Bit

  Hi, Over the past few days I have been investigating encrypting a database under the above version …

  danielle.shaw

  17 replies

  13 years, 10 months ago

  By: Elliott Whitlow

• SQL Server alert jobs

  I would like to create alert jobs in case anything goes wrong. -- Need an alert if Parallelism valu…

  espanolanthony

  1 replies

  13 years, 10 months ago

  By: Steve Jones - SSC Editor

• Restore incorrect log backup does not result in error

  Hi, I'm running some spot restore checks on the new backup jobs which i have created and i decided …

  DBANewbie

  1 replies

  13 years, 10 months ago

  By: Steve Jones - SSC Editor

• Maintaining a read-only copy of a database on a different domain

  We have a production database which is hosted within our company, but in a separate domain. We have…

  Phil Parkin

  3 replies

  13 years, 10 months ago

  By: Perry Whittle

• "No replicated transactions are available" On distributor. Transactional Replication

  I am getting "No replicated transactions are available" on distributor on my transactional replicat…

  Vivdix

  2 replies

  13 years, 10 months ago

  By: Vivdix

• Alias for SQL Server does not function

  Dear All I have installed a developer version of SQL Server 2008R2 on a Server machine. I created a…

  Igor Micev

  3 replies

  13 years, 10 months ago

  By: Nicholas Cain

• I want to move a database server to server without using Backup and restore?

  I want to move a database server to server without using Backup and restore? Example: I am having a…

  ARUN KUMAR AGUNURU

  13 replies

  13 years, 10 months ago

  By: Daxesh Patel

• CDC and replication

  Hello everyone, Not sure if anyone had to deal with this scenario like mine but hopefully someone c…

  SQL_Baltimore

  6 replies

  13 years, 10 months ago

  By: SQL_Baltimore

• Granting datareader access to a user for objects in a schema

  Hi When trying to grant datareader access to a user in a non dbo schema he is unable to view the ta…

  Kwisatz78

  8 replies

  13 years, 10 months ago

  By: SQLRNNR

• How to dicrease the ram utilization

  Hi Here i have one doubt. We are having 28gb ram in that after installing the sql server it is occ…

  New persopn

  18 replies

  13 years, 10 months ago

  By: Gail Shaw