Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

server 08 log file


  • Please log in to reply
2 replies to this topic

#1 trevorcork

trevorcork

  • Members
  • 346 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Ireland
  • Local time:04:10 PM

Posted 08 April 2016 - 09:43 AM

Hi im trying too back up a log file its 15GB it needs too be back u0p, but im getting the error -this action cant be completed because this file is open in SQL server (relate), i was trying to copy and paste it too external drive but cant, any way around this cant shut down SQL its in use



BC AdBot (Login to Remove)

 


#2 x64

x64

  • Members
  • 352 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:London UK
  • Local time:10:10 PM

Posted 08 April 2016 - 01:57 PM

I suspect the "log file" is a file which is part of the SQL database - I think that it is a "transaction log" file (as opposed to any kind of diagnostic log). It sounds as if you have not been correctly backing up and maintaining the SQL database which is associated to lthat log file.

 

The transaction log file contains all changes to the SQL database, is used to ensure integrity of the database.Normally when the database is correctly backed up, it is cleared down . If SQL databases are not backed up correctly, that file wlil grow and grow...As part of a full SQL backup, (the file size of the log file does not shrink, but the data inside is deleted, and after the backup, the free space gets reused.

 

I'm not a SQL server expert (so I can't talk you through ste- by-step), but basically you need to do a full backup of the SQL server databases (through an SQL aware backup program, or through SQL server management studio). As part of the backup, you need to specify that the log files are truncated. Then once done, you can use SQL server management studio to "shrink" the now empty log file. Note that a normal file/folder backup wil not backup SQL databases, or manage the transacion log files.

 

If you have support on the program that uses the database file, the support company might be able to help you do the backup, truncation, and shrink, and then set up a maintenance plan to backup the databases abd maintain them periodically,

 

x64



#3 ServerTech

ServerTech

  • Members
  • 5 posts
  • OFFLINE
  •  
  • Local time:10:10 PM

Posted 08 May 2016 - 12:21 PM

A decent guide for how to do SQL Server backups can be found here:  https://msdn.microsoft.com/en-us/library/ms187510.aspx






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users