Server Configuration

xp_sqlmaint
I have a fixed size log file. I have setup a job using xp_sqlmaint to backup log every five minutes. In monitoring used log space, I find that the used space is the same as before running log backup. Shouldn't the used log space be freed after log backups? Thanks in advance ... 27 Jan 2010 10:23

New store procedure template
Sentences below are from the new store procedure template. Do I need all of them? SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET NOCOUNT ON -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201001/1 ... 25 Jan 2010 11:41

Sql Server express 2005 trying to install BIDS
I downloaded the only setup program for the Toolkit for sql server express 2005 and am trying to install just BIDS which I do not have on my system but I'm getting an error that says it is already there and the details say: Name: Microsoft SQL Server 2005 Tools Reason: Your upgrade is blocked. For more informat... 24 Jan 2010 07:54

Connect to SQL Server 2008 - Express
I am trying to connect from another server (either a web application, or even using SQL Server), to an instance on my laptop. I have enabled all the settings that I felt were needed based on research...but still cannot connect. I get the following error. A network-related or instance-specific error occurred whil... 21 Jan 2010 19:13

Wait Types
We have a server hosting some large data warehouse databases which is experiencing slowness during the day. We are fairly sure that the main culprits are poorly written SQL and the SAN. We mirror the databases from this server to another to provide an isolated environment for reporting. When we look at the DM... 23 Jan 2010 12:05

Corrupted .mdf file.
Can you send me the file so I can take a look at it. Gr. Bjorn From http://www.developmentnow.com/g/118_2003_8_0_0_462025/Corrupted-mdf-file-.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 21 Jan 2010 12:21

SQL Server 2008 on Windows 7 - Error 15401 Can't create login
I am unable to create a new windows autentication SQL Server login on my system. It is a 32 bit SQL Server 2008 (Developer Edition) on Windows 7. Whenever I try to create the login, either in SSMS, or with T-SQL, I get an error 15401 - Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 49 Windows NT u... 2 Feb 2010 17:35

Import data from Access to SQL
Hello everyone. I have an instance of SQL Server 2008 Express on my PC, I have need to export tables from Access 2007 to SQL. I did successfully migrate (table access with unique ID field primary key) with SQL Server Migration Assistant for Access 2008, I rechecking the tables in SQL and it's all ok. Linking ... 23 Jan 2010 12:05

Recover records from ldf file.
A customer suffered a hardware failure and managed to recover only the SQL Database *.ldf file from the failing hard drive. The *.mdf file was lost. The recovered *.ldf file is huge. The drive they were backing up to is full and the last backup is dated October. I believe that backups have been failing since Oc... 21 Jan 2010 14:38

dfrgifc.exe & dfrgntfs.exe starting for some reason
We have a cluster consisting of two Windows Server 2003 R2 nodes. SQL 2000 is installed on the nodes and a data array is connected to the active node. We noticed that the above processes start at some time because we see them in Task Manager. We cannot figure out what is launching them. Sometimes, there are... 2 Feb 2010 17:35