Administering

• Topics

  Started by

  Posts

  Last post

• copy files through network to another server

  I'm planning to upgrade sql server 2005 to 2008. For now I'm just planning on it. If we use side by…

  sqlfriend

  21 replies

  12 years ago

  By: sql_novice_2007

• Not able to run Analysis Services

  Hi All, Can anyone suggest me for the Following Error when i start the analysis Services in sql 20…

  venkatg86

  7 replies

  12 years ago

  By: 205.dileep

• Granting Access to Analysis Services

  I can't seem to access Analysis Services using SSMS or create a data source in BIDS for Analysis Se…

  //Ravi

  2 replies

  12 years ago

  By: //Ravi

• Link SQL Server (x64) to MySQL with ODBC

  Hi Guys, Was wondering if you can please help, I am connecting our x64 2008r2 SQL Server to MySQL u…

  rgillooly

  2 replies

  12 years ago

  By: khaqanbaloch

• Minimal permission required to read the Errorlog file.

  Hi Guys Can you let me know what is the minimal level of access is required to read the SQL Errorlo…

  SQL_Hunt

  2 replies

  12 years ago

  By: SQL_Hunt

• Does differential backup creates LSN ?

  Hi All, I have a query regarding differential backup. I have taken full backup F1 and Differential …

  beejug1983

  2 replies

  12 years ago

  By: beejug1983

• What happens when we take SQL Server Full backup

  Hi All, Please explain; what exactly happens internally in SQL Server when we take database full ba…

  beejug1983

  3 replies

  12 years ago

  By: beejug1983

• Reportserver URL is working reports URL is not working

  Hi, We have sql server 2005 reporting services. When I browse http://servername/reportserver --- it…

  rambilla4

  3 replies

  12 years ago

  By: Snigdha Vartak

• Delete .bak & .trn

  Anyone has a script which would delete old backups (7 days old) in each database directory folder. …

  kd11

  3 replies

  12 years ago

  By: homebrew01

• Unable to access SQL Instance

  Hi, I am in desperate need of some help with a problem I am having. SQL Server 2005 named instance …

  alex.winser

  1 replies

  12 years ago

  By: alex.winser

• Job Fails 1/2 Way Through When Scheduled, Completes Manually

  I've got a bit of a puzzle. I have a job that restores the production databases to reporting server…

  homebrew01

  1 replies

  12 years ago

  By: Jeff Moden

• Is it better to archive data into a single table or multiple tables?

  Hi, I currently have a main table that keeps 7 days worth of records and anything older than that i…

  myoda

  2 replies

  12 years ago

  By: Jeff Moden

• Dumb question of the day - logins with $ at the end?

  What type of logins are these? Thanks for your time.

  snomadj

  2 replies

  12 years ago

  By: HanShi

• Using contig.exe to defragment an open .mdf file

  One of our database .mdf files was set to increase in 1mb increments and is currently in several th…

  subotai

  1 replies

  12 years ago

  By: Gail Shaw

• Is simple select statement taking TEMP DB space during execution ?

  Hi, I have one simple question.... because I don't know about this fact. I have one invoice table w…

  dsachu

  2 replies

  12 years ago

  By: dsachu