.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

Backing up and truncate log fast

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

Hello all,

What are the problems that the following backup method can create:

Backup Log "database_name" With Truncate_Only

Also, if this method is not preferred, which backup method should be used to backup and truncate Tlog fast in a case of emergency?



View Complete Post

More Related Resource Links

XmlLite: A Small And Fast XML Parser For Native C++


XmlLite provides a high-performance, low-overhead XML reader and writer geared for applications written in native C++. Learn more here.

Kenny Kerr

MSDN Magazine April 2007

Best Practices: Fast, Scalable, and Secure Session State Management for Your Web Applications


ASP.NET provides a number of ways to maintain user state, the most powerful of which is session state. This article takes an in-depth look at designing and deploying high-performance, scalable, secure session solutions, and presents best practices for both existing and new ASP.NET session state features straight from the ASP.NET feature team.

Mike Volodarsky

MSDN Magazine September 2005

Windows Forms: Give Your .NET-based Application a Fast and Responsive UI with Multiple Threads


If your application performs any non-UI processing on the thread that controls the user interface, it may make the app seem slow and sluggish, frustrating users. But writing multithreaded apps for Windows has long been restricted to C++ developers. Now with the .NET Framework, you can take advantage of multiple threads in C# to control the flow of instructions in your programs and isolate the UI thread for a fast and snappy user interface. This article shows you how. Also, it discusses the pitfalls of multiple threads and presents a framework for safe concurrent thread execution.

Ian Griffiths

MSDN Magazine February 2003

FAST Search for SP2010 scope setting works but not getting results.



I am trying this from last two days , but it does not work. I have created two scopes for FAST Search Query SSA , they appear in search center , but I am not getting any results back. I see them being fired in the FAST query log.

First one is a simple one:

New-SPEnterpriseSearchQueryScope -SearchApplication "FAST Query SSA" -Name DCO -Description "All DCO Documents" -DisplayInAdminUI 1 -ExtendedSearchFilter "ContentSource:DCO"

Content source is a managed property. and i can just query "contentsource:dco" from the text box which gives me results.

When I fire the query i see it in FAST Search query log

"GET /cgi-bin/search?qtf_keyword:context=ssgid%3a%3a4d020606-8532-45d8-b09a-db11283cccb4%7cSPS-Location%3a%3a%7cSPS-Responsibility%3a%2c%3a%7c&rpf_navigation:hits=50&rpf_navigation:enabled=True&spell=suggest&qtf_parsekw:timezone=10&type=kwall&qtf_teaser:dynlength=185&resubmitflags=8192&language=en&query=CASHIERING&sortby=%2bdefault&qtf_lemmatize=True&offset=0&version=

Workflow E-mails with Long Text Truncate the Text

The title is pretty self-explanatory.  I have a few fields that are generated from some Infopath Forms.  The text, however, truncates and doesn't display the entire text.

Anyone have any suggestions?

FAST Search for SharePoint Server 2010 SDK

Learn how to develop and deploy search solutions in SharePoint Server 2010.

FAST search query is slow...

Hi, we are using fast search for sharepoint 2010. We are crawling an external data source and this is used for search queries. we have around 30 metadata properties and all are full-text indexed. however, the search operation is slow for a database of 5k records in intranet (webserver and database server are in different geographic regions). typically a 100 item search takes 9-10 sec. it get worse over internet and the search query varies from 10-45 sec for 100 items. Any pointers will be helpful. thanks.  

How can i truncate a published table?

I need to replicate our production tables to another server. Unfortunately there are 2 refresh jobs that runs at night that truncates the tables completely and refreshes it with fresh data. How can i setup transactional replication or any type of replication? Is there a way around this? thanks in Advance!

Restrict Truncate Table?

How to restrict 'truncate table' in a database from a user? Thanks !

Backing Up & Restoring Data.

Hello, I'n new to the SQL Server Management Studio 2008, What i have done so far: I have opened my file Datebase Selected a subfolder inside the Database called "World00" I have backed up my World00 into my Hard Drive file called World00.bak But when i open my SQL Server Management Studio 2008, my World00 is "(Restoring) i seen some videos something about a Log that i also need to restore but where can i find that log? how do i make my file come back so i can go in it and use it? and also: http://img827.imageshack.us/img827/7172/problem2.jpg Can somebody please explain to me what do these options mean? Restore Options like (WITH REPLACE), (WITH KEEP_REPLICATION), Prompt and (WITH RESTRICTED_USER) Recovery State (RESTORE WITH RECOVERY), (RESTORE WITH NORECOVERY), (RESTORE WITH STANDBY) When i clicked on my World00 I selected (WITH REPLACE), and now i think i messed it up..is there a way to recover myfile back? so i can use it? because its still on "Restoring" please help! Also i did it all the way through like Manualy i didn't put any codes SQL's Query thing because i dont know how to use them if your going to give me a Query please tell me what to do, sorry i'm new to this coding ;o All i would like to know is how to backup ~ well i know this just right click on file select full backup and job done, but restoring is kinda confusing me because i

C#: How to add a row to a child table with a DataSet backing?

On the back end I am using XML files, xsd schemas a DataSet(dsThingPrograms) and DataTables. I have a parent ->child table relationship defined through the DataSet designer as such:   things[RFID(pkey), name] programs[ID(pkey/autogen), name, path, thing_RFID(FK references things->RFID)]   In my code I have:   dsThingPrograms.things.AddthingsRow("lala" , "00ffe4" ); dsThingPrograms.things.WriteXml("path\to\things.xml" , System.Data.XmlWriteMode.WriteSchema);   which works fine. However the problem comes when I try to add a row to the Programs table. When I do:   dsThingPrograms.programs.AddprogramsRow("someprog" , "some\path" , <???>);   VS wants me to add a "dsThingPrograms.thingsRow parentthingsRowByFK_things_programs" where the <???> is. I've tried a bunch of things but I could not satisfy that requirement and can't even get the code to compile. What is supposed to go in there to satisfy the FK property?

Cannot connect to FAST Search server

From the ULS: Failed to connect to myfastserver.mydomain.com:13391 sp. Error=Failed to initialize session with document engine: Unable to resolve Contentdistributor  [documentsubmitterworkerthread.cpp:132]  d:\office\source\search\native\gather\plugins\contentpi\documentsubmitterworkerthread.cpp Docpush -c sp myfile.txt works fine. And I can do a search from FAST search center and find the new file. Q1: How do I determine if SSL is working correctly between my SP Server and my FAST Search Server? Q2: The FAST Search server has port 13391 open. Does this port also need to be opened on the SP Server or are all communications (crawling etc) made over port 443? Q3: Why does the error refer to d:\office... when this the DVD drive (place FAST was installed from)

FAST Search crawl queue

I am attempting to do a full crawl (FAST Search) of a handful of Word, Excel, PowerPoint documents. Has been running for ~3 hours. If I look at the Crawl Queue report in the Administrative Report Library it shows 150 transactions queued. Crawl Processing per Activity - the last entry on the graph is 300 seconds for Initializing Document Filtering for what looks like the entire 2 hrs SQL Server, SharePoint Server and FAST Search servers appear to all have low utilisation (cpu, memory, disk). There are only 2 warnings in the FAST Search crawl log (don't crawl search site and search cache directory). Success = 0, Error = 0, Warning = 2. Before I setup FAST Search, SP Search took approx 6 minutes to crawl a similar list of documents. How do I troubleshoot the issue?

Fast Search Server 2010 on Windows 7

Is it possible i can install Fast Search Server 2010 for  sharepoint  on windows 7 ?   Thanks in advancehttp://mykbdump.blogspot.com/

MOSS 2007 Metadata using FAST 2010

Is it possible to include custom metatdata from MOSS 2007 sharepoint sites in the crawled index using Sharepoint 2010 with FAST?  If so can you include the steps to configure this correctly.  I am able to crawl and search MOSS 2007 sites but the custom metadata is not available in the results.

FAST Search navigation

So, I have created a FAST Search and it works ok. My problem is that I cant get navigation to show up on FAST Search center. I would like just like other sites to have links that lead to our Portal and also to other sites. Not matter what I do it does not show up. All I see on the top left is FAST Search - Search. Any ideas?

FAST Search Installation Problem

I tried the post install step for Fast Search on a Windows 2008 server without domain names (I used local user names only, due to constraints of our sandbox machine on our production network). The post-install step failed. In the installer log file I see: 1/4/2010 2:13:18 PM Verbose InstallAction - Creating IPSec configuration... 1/4/2010 2:13:22 PM Error Utility.WriteException - Exception -  : Exception - System.ArgumentException: A problem occurred when retrieving information on machine: watsdevsp2010. Make sure the machinename is spelled correctly and that the machine is available ---> Microsoft.SharePoint.Search.Extended.Installer.Mahasen.Common.IPSec.IPSecException: Exception occurred while looking up SID for machine: "watsdevsp2010". LDAP filter: "(&(objectCategory=computer)(objectClass=computer)(cn=watsdevsp2010))". Path: "LDAP://DC=watsdevsp2010". ---> System.Runtime.InteropServices.COMException (0x8007054B): The specified domain either does not exist or could not be contacted. where it fails an IPSec configuration step. I tried commenting out C:\FastSearch\installer\scripts\psconfig.ps1 file where the steps are for "Creating IPSec configuration", but apparently this file is dynamically created and overwrites my commenting out of this step. Has anyone successfully installed FAST search in a local account only scenar
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