.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

log files doesn't clear after full backup

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server

I have SQL 5 and for some odd reason log files doesn't clear after Full back up.  I have to manually shrink the log files.

can someone explain what could be wrong

View Complete Post

More Related Resource Links

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

SQL2008 - Cannot Restore a new database from a full backup of a different one, database in use

I am trying to restore a brand new database from a copy of another one and am encountering an error message stating: System.Data.SqlClient.SqlError: The file <Backup source database file location> cannot be overwritten.  It is being used by database <Backup Source Database>. (Microsoft.SqlServer.Smo) I am running the Restore procedure with the REPLACE option and am wondering why it is stating that the source database is the database in use when I am trying to restore and overwrite a completely different database. This issue happens when running the replace both in C# using SMO and when manually restoring with SqlServer Management Studio Interesting note is, the original source database is created / deployed using a database project within VisualStudios 2010 and then deployed to SqlServer through VisualStudios. Any thoughts on why this is happening? Thanks in advance for any help!

Sql Server 2005 backup misses files

I have a SQL Server 2005 database that contains 3 files.  Sometimes when I run rhe backup, it appears to only backup 2 of the three files.  The only way I can get it to return to a full backup is to restore the database from a backup tape.

Full Backup

Hi All, I want to do a Full Backup Daily but is there a way of doing a complete Full Backup by writing over the pervious day full backup. I have done Differential backups by using INIT keyword but I wanted to be sure that I can use it for Full backup as well. Thank you    

Why doesn't SQL Server 2005 Enterprise always shrink a log file after a backup?

I have several databases that, despite being backed up regularly, do not release space to the operating system.  In one extreme case, I have a log file that is less than 1% utilized (and has been for months.) I know how to manually force a shrink, but I should not need to do that on any sort of regular basis.  In fact, it is against best practices to manually shrink a log file (or any database file for that matter) because of the very high risk of an unrecoverable error. It is my understanding that SQL Server will eventually handle these things on its own.  However, it does not appear to be doing so.  Any thoughts as to why? Thanks, Dave

Full database backup takes so long

Today several full database backups took so long. Normally it took 2 hours to backup. But today the 5 backups didn't finish by the end of the work day. The backups went well until yesterday. I don't know what happened overnight. Is there a performance tool embedded in SQL Server? How can I find out why the backups take so long? What could be the possible reasons? Thank you,  

Full Farm Backup Fails on Windows Sharepoint Services Search Database

I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

How to determine a partial vs full backup set?

I've written application that uses SMO to backup / restore database. I largely mimic the interface found in SQL Server Management Studio 05. In the restore display I display all available backup sets and I query msdb to get the info for each backup set via the following query: "select backup_set_id,name,description,recovery_model,type,server_name,database_name,position,  backup_finish_date,backup_size,user_name,expiration_date  from msdb.dbo.backupset Where msdb.dbo.backupset.database_name = '" + dbName.Text + "'"; How do I determine if the backup was full or incremental, so I can set the Partial property??

Delete Old Backup Files that are saved in .RAR format



I have configured my SQL Server 2005 to take backups and I have another program running to compress these files to .RAR extension to save space.

I have a Maintenance Cleanup Task also configured to delete old .RAR files but it does not work.  I have specified the extension to look for to be RAR and the job runs without error but no files are deleted.

Is it that only BAK and TRN files are deleted using Maintenance Cleanup Task?

Moving full-text catalog from one server to another using backup / restore


Dear Sirs,
I'm having a problem with Full-Text Catalog in SQL SERVER 2005.
The problem is: I did a backup of a database that has a full-text catalog from one server and restored on another server.
The restore worked perfectly, but the catalog is down because it is pointing to the physical path from the source server.
To recover this full-text catalog I tried the commands below:

use master

sp_detach_db 'SiteEng2004'

(FILENAME = 'D:\SQL SERVER\DADOS\SiteEng2004\SiteEng2004_Data.MDF'),
(FILENAME = 'E:\SQL SERVER\LOGS\SiteEng2004\SiteEng2004_Log.LDF'),

Unfortunately it did not work and the following error message occurs :

Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "D:\SQL SERVER\DADOS\SiteEng2004". Operating system error 5: "5(error not found)".

Could anyone help me on what I should do to restore this full-text catalog on the destination server ?
Thanks in advance.

Maintenance Plan - Full Backup


Hey all

I am running a maintenance plan (Sql Server 2008 Enterprise) every night at mid-night. All the plan entails is doing a full backup of one database (about a 3GB database). We are getting timeouts on our site at exactly that point when the database is being backed up and they last up to 20min. I was under the impression that doing backups this way does not take the db down? Or am I wrong about this?

Has anyone else experienced this and if so what steps did you take to rectify it? Sorry if I have not provided other information, just let me know and I will give it to you.


Can't full text search pdf files


I have a MyDocuments table that has the following columns: ID, Document varchar(max), and DocumentType

I'm only able to get HTML and TXT results from my full text search queries -- but I know that I should be getting PDFs as well.

What am I doing wrong?

FYI: I did install the iFilter.

returning backup files to applications


Hi all.

I want to send a backup command to sql server and return backup file to my c# application.

sql server is another machine and I have not access to its hard disk.

What should I do for that?

returning backup files to applications


Hi all.

I want to send a backup command to sql server and return backup file to my c# win application . sql server is another machine and I have not access to its hard disk.

What should I do for that?

All problems have a solution.

Why is SQL 2000 Backup causing pre-shrunk (non-primary) filegroup files to grow?


I start off with an NDF file:-

07/01/2010  07:30 PM        65,404,928 sales_month199701.ndf

I use shrikfile to shrink it down:-

10/14/2010  08:08 PM        30,408,704 sales_month199701.ndf

I run a backup, and the size grows back again!

10/17/2010  06:51 PM        65,404,928 sales_month199701.ndf

Why? Will it make a difference if I set autogrowth off, and/or if I set the filegroup or file to read-only?


Andy Abel

Text from RequiredFieldValidator doesn't clear after picking date from jQuery UI DatePicker


I'm trying to use a RequiredFieldValidator with a TextBox that has a jQuery UI DatePicker attached to it. I'm finding that selecting a date from the datepicker does not trigger the RequiredFieldValidator to recognize that a value is now present. Thus, only server side validation is working for the RequiredFieldValidator and not client side. Any ideas on how I may fix this issue so both client side and server side validation fires?

Below is some sample code of this issue. To reproduce this situation: 1) Click the PostBack button (RequiredFieldValidator will indicate field is required) 2) Pick a date using the date picker 3) Notice that the RequiredFieldValidator's text still displays when it shouldn't.

<%@ Page
    Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">




        rel="stylesheet" />


Sharepoint backup and LDF files



I am running WSS 3.0 on W2K3 box. I am using stsadm to do a full backup that is scheduled in System Tasks. I then backup the .bak file with 3rd party to tape.

I have noticed that the sharepoint_config.ldf and WSS_content.ldf log files are 17 and 1GB respectively. I thought that doing a full backup clears the LDF files. Isn't this the case? If not, how can they be reduced?

And based on my backup method mentined above, can I assume we're safe for failure, and all I'll need to do is restore the .bak file?

Thanks in advance.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend