.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

truncate_only' is not a recognized BACKUP option

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :Sql Server
Hello All,I am able to run the below command in sql 2005 but in 2008 getting error : truncate_only' is not a recognized BACKUP option.Back Up Log [DBName] with Truncate_Only  dbcc shrinkfile([logFileName]) Thanks in AdvanceAshwin

View Complete Post

More Related Resource Links

'Initialize with backup' Option in transactional Replication


We have set 'Initialize with backup'  while intialially restoring the backup over subscriber.My question is

When there is a failure on sunscriber or agent will I be able to reintialise the snapshot without changing any setting?


What are the recommended replacement commands for BACKUP LOG xx WITH TRUNCATE_ONLY followed by DBCC SHRINKFILE (xx_Log, TRUNCATEONLY)  ??


Okay...seriously. Could someone from Microsoft who monitors this board please tell me why you decided to remove that functionality?!?!? So every time I have an issue with a log getting full, I have to go in, switch the mode to simple, and then switch it back?!?!

Pardon me for saying, but that just seems kind of a pain in the posterior...
A. M. Robinson

Restore database backup with Copy_Only option failed ?


When we failed to restore a backup from a BAK file for SQL Server 2008.


Then we find that the backup is created by using BACKUP xxxx COPY_ONLY parameter.  When we attempt  to restore from Management Studio (with the database changed to single user mode), we get the error message "There is NOTHING in the "Select the backup sets to restore".


We would like to seek your advice on

1) Whether we can restore the database from Management Studio GUI ?

2) If not, can you suggest a SQL Script for the backup ?


Thanking you in anticipation.

Sync with backup option

We are using SQL 2005 and plan on transactional replicating a database where the transaction log is backed up and truncated every hour. If we schedule the replication to occur every half hour how can I guarantee that the transaction will make it to the distribution database before they are truncated. Should I set the IsSyncWithBackup?

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:

VS 2010 HTML validation "in CSS" option - where the hell is it?


In VS 2008 there is a very useful feature of background HTML validation - it checks if CSS class name is valid i.e. it exists in one of the linked css files. But VS 2010 Express does not do that any more. And the relevant setting in Options->Text Editor->HTML->Validation->in CSS is not there. Ok, maybe they made it paid for option? VS 2010 Professional? Not there. Or maybe VS 2010 Ultimate? Not a trace.

1. am I blind?

2. they decided it is too convenient to use and removed it?

3. they will "introduce" it in SP1?

What is going on? That one thing made me move back to VS 2008 web developer.


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

RDLC Report Hide Export Option

The article RDLC Report Hide Export Option was added by mandandeo on Sunday, August 15, 2010.

protected void ReportViewer1_PreRender(object sender, EventArgs e) {DisableFormat(ReportViewer1, "Pdf"); }protected void DisableFormat(ReportViewer viewer, string formatName) {const System.Reflection.BindingFlags Flags =System.Reflection.BindingFlags

search option



i've created a gridview and connected to the database programatically. now i want to insert a textbox above the header field of the name field. if i enter the name in the textbox it should display that only.. e.g i have three header name,pwd,sex i want to create the textbox above the name header. now i enter the name jhon in the textbox then the gridview should display

only the jhon information

please can u provide me a code...

V1.1 to Beta 2 - Namespaces Not Recognized


We are attempting to test out a website written in VS2003/.Net 1.1 in VS2005 Beta 2/.Net 2.0.  Our main problem at this point is that certain classes are not being recognized when they are referenced in other files not in the same directory as the class file.


A Framework.cs file under \Applications is inherited by several other webpages. It resides under the namespace Company.WebSite.Applications.

Another class, SearchHistories, is in \Applications\CrackHistory directory. The namespace of SearchHistories class is Company.WebSite.Applications.CrackHistory. SearchHistories inherits Framework.  Under .NET1.1, there was no problem with this. However, in VS2003, a compile error states "The type or namespace name 'Framework' could not be found (are you missing a using directive or an assembly reference?) C:\WEB\Applications\CrackHistory\SearchHistories.aspx.cs".

The immediate solution is to copy the Framework.cs file from the Applications directory and copy it into the Applications\CrackHistory directory. Then the error goes away. What is up with that?

Attach Workflow to Task List, don't get option to manually start workflow via dropdown on task item



I am running WSS 3.0 with other workflows which are functioning correctly.  I created a new workflow in Visual Studio 2008 and was able to successfully run it in my dev environment.  I attached the workflow to a task list in my dev environment and was able to manually start the workflow by using the drop down workflow option and using the menus to manually start it.  I installed this workflow in our production environment and attached it to the task list (which had a SPD workflow attached to it which stopped working about a month ago).  I made sure that the option to manually start the workflow was checked.  When I tried to manually start the workflow, (hover mouse over title, drop down) there isn’t a workflow option.  The workflow also will not start automatically when a task is changed.


I attached this same workflow to a different task list in production and get the option to start it.


I have tried creating a small workflow in SPD 2007 and attaching it to the task list.  It shows that it is attached, when I look at the workflows that are attached to the task list, but I still don’t get the option to manually start it.


I have checked my security and I have fu

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

WPF+ VS2010: Design mode error "The URI prefix is not recognized"?

our application uses VS2008 and WPF. To apply the styles in the design mode, we have used the "BlendMergedDictionary" class (see the following link) http://stackoverflow.com/questions/995101/how-do-i-get-wysiwyg-design-in-blend-vs-without-merged-resourcedictionary-in-ever It works very well in VS2008 IDE. Now we plan to move our application to VS2010. In VS2010 Design mode (click on ~.xaml design), we get error message:  "The URI prefix is not recognized."    at System.Net.WebRequest.Create(Uri requestUri, Boolean userUriBase)    at System.Net.WebRequest.Create(Uri requestUri)    at MS.Internal.WpfWebRequestHelper.CreateRequest(Uri uri)    at System.Windows.ResourceDictionary.set_Source(Uri value) the styles does not apply at the design time. It works fine in runtime. The following are the code: public class BlendMergedDictionary : ResourceDictionary { /// <summary> /// This class the purpose is allow we reference the "themes" and "styles" in resource dictionaries in separated assemblies /// by using StaticResource. The big problem using StaticResource is that it will complaints at design time can not find the resources /// So we use this class in xaml file, if it is design time, it will load the resource dictionaries in. /// If it is not in design time, it will use the reso

Multiline Option does not work

Hi,Below is the sample piece of code(The code is in VB.NET), where I am expecting an answer of "true" with my basic knowledge of Regular Expressions.---------------------------------------------------'VB   Dim r As New Regex("^def$", RegexOptions.Multiline)   Dim d As String = String.Format("{0}{1}{2}{3}{4}{5}", "abc", System.Environment.NewLine, "def", System.Environment.NewLine, "def", System.Environment.NewLine) MsgBox(r.Match(d).Success)-----------------------------------------------------------The answer I get is false, but there are two "def" in 2nd  and 3rd line of the data and Multiline option is enabled, I have checked it with VS 2005 and VS 2008, both give me answer as false.  What is the mistake I have done? Please help.Thanks and Best Regards,Bennz Benz

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=
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