SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• SQL named instance alias as server name

  Hi, I've got an old apps, which is pointing a database on a named instance SQL e.g. servername1\ins…

  dr.kusnadi

  11 replies

  13 years, 8 months ago

  By: dr.kusnadi

• Want to import all the jobs from one server to another

  I am trying to build new server SQL 2008 R2 64 bit, and want to import all the databases and jobs, …

  bubby

  6 replies

  13 years, 8 months ago

  By: bubby

• Move File contents to other

  Hi, 1. How to move one filegroup content to the other filegroup using syntax? Is this just a simple…

  SQL_Hunt

  4 replies

  13 years, 8 months ago

  By: SQLRNNR

• sp_addrolemember with Map

  Hi, I had a request to give a new login datareader access to all databases within an instance. Not …

  PHXHoward

  4 replies

  13 years, 8 months ago

  By: PHXHoward

• Procedure sp_change_users_login error

  Please Help, I am a newbie! I just upgraded a database from SQL Server 2000 to 2008 R2. The last s…

  chumphrey 12211

  7 replies

  13 years, 8 months ago

  By: chumphrey 12211

• windows update

  Any dba do windows update for SQL servers, any experience of that? Thanks

  sqlfriend

  13 replies

  13 years, 8 months ago

  By: Steve Jones - SSC Editor

• SQL Consolidation

  Dear all, I'm working on a SQL Server consolidation. There are 2 SQL Server installation (with DR, …

  julieng

  1 replies

  13 years, 8 months ago

  By: heymiky

• SQL Data Migration From 2005 to 2012 By:Shubham Saxena

  Dear Friends, I am having a database ODMS having size approx 1 GB having lot's of tables having ind…

  shubham.saxena67

  1 replies

  13 years, 8 months ago

  By: Suresh B.

• Quci question please

  I am working as sql DBA, i gave access to one user to dev server. He need to run only jobs. So i ga…

  sqlmaverick

  4 replies

  13 years, 8 months ago

  By: Jack Corbett

• SQLIO interpretation

  I have a shared EMC VNX 5300 SAN on which a SQL Server DW is to be deployed. The SAN already suppor…

  Sachin Nandanwar

  2 replies

  13 years, 8 months ago

  By: Rudyx - the Doctor

• Database functionality is not available in the current edition of SQL Server.

  I am currently using Dev edition. I did a backup on dev edition and tried to restore on Standard ed…

  DBA_Learner

  4 replies

  13 years, 8 months ago

  By: DBA_Learner

• SQL 2005 Database Mirroring Error

  Hi, I want to know regarding Mirroring configuration on two different server 1. Is it neccessary th…

  farrukh635

  2 replies

  13 years, 8 months ago

  By: Suresh B.

• Amount Of Admin Required

  Hi, I am currently working to win a project for development of an application that will use SQL Ser…

  dec_obrien

  8 replies

  13 years, 8 months ago

  By: dec_obrien

• change email server name, do I need to restart Reporting service

  Anyone knows if I change email settings in Reporting server configuration screen, do I need to rest…

  sqlfriend

  3 replies

  13 years, 8 months ago

  By: SQLRNNR

• server name after migration

  We are doing some migration from SQl server 2005 to 2008 R2. We migrate from an older server to new…

  sqlfriend

  26 replies

  13 years, 8 months ago

  By: sqlfriend