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

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

SQL backup takes forever

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

Esteemed users,

I have a database to backup. It used to take about 20 minutes. Now it has taken 1600 and 1700 minutes for the last two days. When I checked the processes in the server one process takes 2 billion CPU time. Can I conclude that this is the culprit?



View Complete Post

More Related Resource Links

Services takes forever to fire up....

Is there some magic way to keep the services alive?...I think IIS keeps shutting it down and when I make a call I have to wait like 10-15 seconds for it to respond :/

Windows 7 - Takes forever to wake up from sleep mode

I check the event viewer (under applications) and see this error message: The remote name could not be resolved: 'HTC-media'   at System.Net.HttpWebRequest.GetResponse()    at MSSConnectorService.MSSLongPoller.Poll()   I think this was from my HP media server, but I was getting the same slow wake up time before I got the server?  Could this be the cause?  I have a Gigabyte UD4P-55A motherboard running windows 7 64-bit, 8 GB RAM, and a ATI 5750 graphics card with the latest drivers installed.  Please advise.  Thanks.    

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,  

MSSQL 2008 R2 - database in restoring mode after backup - forever..

Hi folks,   i have this problem that occourred today with one instance of MSSQL 2008 R2 running on a WIN x64 R2 enterprise server.   i have run a backup maintainance job and now i have two databases in restoring mode for over 4hrs.   my questions are: why are these databases restoring when i was backing up? and why are they not being logged anywhere - i can not find anything on logs, activty monitor, or even Windows Resource Monitor.   i can not see any work been done by MSSQL to restore these databases, and yet they are set as 'RESTORING'.   any suggestion from the community here will be much appreciated as i am banging my head against the wall already.   thanks,   Nicolas    data warehouse | data migration | ETL/ELT | UK | http://www.brainpowered.net

SP Backup sometimes takes 4h or 6 to 9h...



We have a SP Farm where the Backup sometimes takes 4h (normal) but sometimes takes 6 or 9h.

The strange is that sometimes the backup is 270Gb and takes 4h and sometimes has 240GB and takes 7h...

Good day:

[22-09-2010 3:43:09]: Verbose: [DB1] SQL Server Message: BACKUP DATABASE successfully processed 28.201.667 pages in 13675.925 seconds (16.893 MB/sec).

Bad day:

[23-09-2010 7:36:15]: Verbose: [DB1] SQL Server Message: BACKUP DATABASE successfully processed 29259332 pages in 27657.097 seconds (8.666 MB/sec).


During this time nothing is running, just other backups, and those end always at the same time

Probably a concurrency problem? In SQL IO?

What are the best ways to debug this? Add some performance monitor in Sql?

Thank you.



Requesting Data... takes forever, any idea why?


Lately, when I design my page in the Design mode, I kept getting this "Requesting Data..." at the bottom status bar and the mouse cursor blue circle kept spining. Any idea how to resolve this issue? The site is create within my local hard drive. I've tried created a brand new site with no files to start with and it's still doing the same thing.

Installing SQL Server 2008 R2 takes forever


Hi all.

I'm installing MS SQL Server 2008 R2 on a Windows 2008 R2 VM running under Hyper-V

After a long period of time, nothing happends.  The process that stops is


It has been holding that position now for two days so this morning I decided to terminate the setup.  When I go to COntrol Panel and selects the server for uninstall I get a choice of repair or uninstall.  I thought repair would be the correct choice, but it still stops on the same process.   I dont think anything has hung, but it looks like something is making the installer wery busy. 

Please help

------------------------------------------- Ole Morten Heien HD Software / Advisor AS -------------------------------------------

SQL Server Backup and Restore (video)

Restore your full backup, then run a few queries before you keep restoring transaction logs. Brent shows how to use the Standby option for restores.

In this five minute video, Brent demonstrates how to do it by creating a database, populating data, and then showing what disaster recovery is like by doing RESTORE WITH STANDBY.

How to backup SMS from windows mobile Pocket PC to computer

How to backup SMS from windows mobile Pocket PC to computer

Many Windows Mobile Pocket PC Phone users could not backup their SMS to txt file or view on computer. I found this software offers a SMS Messages backup solution to Backup all SMS messages for Windows Mobile Phones onto computer and keep them safe. Here is the user's guide:

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

STSADM ActivateFeature takes too long



I have a solution installed to a web application, this Web App has a lot of Site Collections, these site collections were created with different versions of the wsp package. What I need is a way of activating the new features on the already provisioned site collections.

At first we made a Web Application scoped feature that went through all site collections that were using our template and then activated the features on each site collection but it was giving us a whole bunch of trouble were the code would skip entire site collections or enter the site collection, changing a field that we used for control and not activating anything... Now we have a Web scoped feature that activates all the features within the site collection at either Web or Site scope that we specify through an XML. This works like a charm for every site collection.

The problem is that we need a way of activating that feature on every site collection so I did a batch file that runs the STSADM ActivateFeature to do this. This also works properly but seing the many site collections that we have it is taking more than an hour and a half to finish the batch; is there a way of optimizing this so it runs quicker?

I think that the batch is actually waiting untill the feature is done activating to start to activate the feature on the next site collection, is there a way of a

MOSS 2007 Backup Strategies

I saw some backup strategy best practices papers stating you could backup the databases and site content separately, but was told by Microsoft that if you do that, and have to do a bare metal restore you will not be able to recover because the site content and database will be out of sync. Does anyone have a proven DR process for MOSS 2007 that they can share? We have Commvault in house right now, but are using it only to backup the databases and file system separately. Should we be using the built in sharepoint backup stdadm(sp?) tools?
John M. Couch Insight Enterprises Inc. 6820 S. Harl Ave, Tempe, Az 85283 Email: john.couch@insight.com

SQL2005 backup Issue

After moving the SPS 2003 portal from one disk to another, I am having a problem in backing up the portal from the spsbackup tool as well as through the SQL Server 2005 database backup option . Following is the error am getting:-   ============================================================================================================================= Backup failed for Server 'sql server name'.  (Microsoft.SqlServer.Smo)   ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476   ------------------------------ Program Location:      at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)    at Microsoft.SqlServer.Management.SqlManagerUI.BackupPropOptions.OnRunNow(Object sender)   ===================================   System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_ix_ContentDatabaseName" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)   ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=

SMO Backup and Restore Help

Hello Friends, I am new to SMO, Till now I have only worked with Selct,Insert/update Queries.. Now I want to Implement some backup and restore feature for my application. I looked at some documents of SMO and found it is possible using SMO. First of all I will explain my situation. My application wants to store data belongs to different companies(which is maintained with in application) in to single database server, Sql server 2008. I am planning to use Partition Scheme function and create filegroup for each company. Advantage here is, taking backup of each company will be easy. I am generating primary key for each table without taking into consideration of companies. In other words Particular table's ID 1,2 belongs to Company A, 3 Belongs to Company B and 5 belongs to Company A... But these data will be split in to Different filegroups using Company ID.(horizontal partitioning) Ok... Now the Problem.. My backup for a particular company was taken successfully. Now I want Restore function. When I am trying to restore this backup to somewhere else. Target database may or may not contain Companies installed. When Restoring Will there be any Primary key Violation? I know one solution is to generate primary key by taking into consideration Company Id. But this will cause a complete rewriting of code, as it contains lot of edit/delete queries.  I want to know, whether the

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!

What happened to the backup and restore classes in namespace Microsoft.SqlServer.Management.Smo vers

I do not see these two classes in version 10 of this namespace and I am not finding any documentation explaining what happened to them.

Can I backup to a UNC destination not part of domain using Proxies?

Hi, I am trying to backup my databases to a UNC destination that is not part of domain (stand alone machine) Can I use proxy accounts, so the database backup engine uses the UNC path using a stand alone machine’s account? If not, how can I handle this situation? Thank you, Max
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