SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• restore db from multiple diff vs last diff

  which option (below) will the restoring the 2nd (last) diff be faster? option 1: restore full (10TB…

  Thanh Ngay Nguyen

  5 replies

  13 years ago

  By: Thanh Ngay Nguyen

• how do you execute t-sql code for each instance on server automatically?

  HI, I have this code below and I have 4 instance of sql. How can I execute this code below for eac…

  JP10

  4 replies

  13 years ago

  By: JP10

• Restore a database with structure but no data

  I'm running server 2008 R2. How do you do a database restore with just structure and no Data? I've…

  forceman29

  5 replies

  13 years ago

  By: Chris Harshman

• fileshare script

  Can someone provide a script(any type batch,powershell....etc) for share the all files of a drive .…

  charipg

  1 replies

  13 years ago

  By: TheMaskedDBA

• command lines to handle cluster activities

  Can someone provide some of the command lines to handle cluster activities , like... taking sql ins…

  charipg

  1 replies

  13 years ago

  By: John Mitchell-245523

• DB Mail issues with DLL

  Dear All, I have been facing the problem when I am sending mail , in example in Test mail I am gett…

  Saravanan_tvr

  5 replies

  13 years ago

  By: Mac1986

• Grant (permission) on database:: ... where can I see these?

  If run the following statement: use someDB; grant select on database::someDB to someuser; Is ther…

  Danah

  4 replies

  13 years ago

  By: Orlando Colamatteo

• SQL Server index fragmentation is high after rebuilt

  I have few indexes in my db, which report high fragmentation even after we rebuild indexes. The pa…

  Luke79

  19 replies

  13 years ago

  By: TheSQLGuru

• SQL versions and editions are supported on Windows server 2012 platform.

  Can some one provide the list for what SQL versions and editions are supported on Windows server 20…

  charipg

  4 replies

  13 years ago

  By: charipg

• network monitor

  Hi, Is there a third party tool (Free or paid) which allows me to monitor the activity of the netwo…

  arkiboys

  5 replies

  13 years ago

  By: Hemant.R

• Slow Full backup in SQL SERVER 2008 R2

  Hi every one, We have database(4.6TB) in SQL SERVER 2008 R2.On weekly bases we take full backup fr…

  Aspet Golestanian Namagerdi

  7 replies

  13 years ago

  By: Ramasankar Molleti

• Slow restore performance

  Hello All, Any thoughts and comments appreciated. I am restoring a 2005 database to 2008 R2. I thin…

  Chrissy321

  5 replies

  13 years ago

  By: Ramasankar Molleti

• Executing Insert statements in a batch / group

  Dear All, Hi! I need to generate Insert scripts of more than 1 million records & execute the …

  bharat sethi

  3 replies

  13 years ago

  By: Bill Talada

• Discrepancy Between sys.dm_os_performance_counters and DBCC SQLPERF(logspace)

  Background - A deployment gone bad. Deployment caused the transaction log to grow to the point wh…

  tim_harkin

  3 replies

  13 years ago

  By: tim_harkin

• Strange blocking issue

  Hi Experts, I came across a blocking issue in which the below two process are involved the second s…

  VastSQL

  4 replies

  13 years ago

  By: VastSQL