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


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

Tempdb is going to full what should we do?

Posted By :Ramesh P     Posted Date :October 30, 2010    Points :10   Category :Sql Server 


step1 :shrink the database

dbcc shrinkdatabase(tempdb,10)

or

step 2 : Need to restart the sql server agent services

You can also find related Interview Question to Tempdb is going to full what should we do?  below: 

What is Full Trust?

  
Your code is allowed to do anything in the framework, meaning that all (.Net) permissions are
granted. The GAC has Full Trust because it's on the local HD, and that has Full Trust by default,
you can change that using caspol . (More...)

Which function is used to perform a full text search on a column?

  
FREETEXT function can perform a full text search on the specified column.

FREETEXT({column/*}, search-string)


It will return the rows with columns that match the search-string. It matches the meaning only not the exact value of the search-string. (More...)

What is the full form of KPI?

  
Key Performance Indicators (More...)

How you will Change application to full screen Mode in SilverLight?

  
Application.Current.Host.Content.IsFullScreen=true; (More...)

What is the basic functions for master, msdb, model, tempdb databases?

  
The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.
The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
The tempdb holds temporary objects such as global and local temporary tables and stored procedures.
The model is essentially a template database used in the creation of any new user database created in the instance. (More...)

What is Full Assembly reference

  
A full assembly reference includes the assembly's text name, version, culture, and public key token (if the assembly has a strong name). A full assembly reference is required if you reference any assembly that is part of the common language runtime or any assembly located in the global assembly cache. (More...)

What is Full Assembly reference

  
A full assembly reference includes the assembly's text name, version, culture, and public key token (if the assembly has a strong name). A full assembly reference is required if you reference any assembly that is part of the common language runtime or any assembly located in the global assembly cache. (More...)

What are the things we have to follow when switching from the SIMPLE recovery model to the FULL or BULK-LOGGED recovery model ?

  
1. Once we complete the switching to the FULL or BULK-LOGGED recovery model, we have to take a full or differential database backup to start the log chain.

2. Then only it takes effect after the first data backup.

3. Schedule regular log backups and update your restore plan accordingly to maintain high-availability/Disaster recovery
(More...)

What are the things we have to follow when swithing from FULL or BULK-LOGGED to SIMPLE recovery model ?

  
1. Before switching from FULL or BULK-LOGGED recovery model, We have to take LOG Backup immediately before switching to SIMPLE.

2. It will help us to recover Point-In-Time(If any)

3. Finally, we can switch to SIMPLE recovery model. (More...)

On a routine monitoring of the data files and transaction log, you notice that the transaction log is extremely close to being full. What will happen if the log fills? What steps can you take to avoid running out of transaction log space?

  
If the transaction log fills, you are unable to modify the data in the database until the log is archived or expanded. To avoid a full transaction log, you can monitor the log space regularly, expand the log whenever necessary, set the log to grow automatically, and create an alert to notify you when the available log space falls below a specified level (alerts are not covered in this training kit). Scheduling or performing frequent transaction log dumps is the best way to reclaim available space in the transaction log.
(More...)

use of tempdb database in sql

  

The tempdb holds temporary objects such as global and local temporary tables and stored procedures. The model is essentially a template database used in the creation of any new user database created in the instance. (More...)

what is the full form of UDDI?

  
Full form of UDDI is Universal Description, Discovery and Integration. (More...)

How do I assign full trust to an XBAP application ?

  
The application crashes due to insufficient access to registry even if you have a local intranet certificate. The issue is, you get access to the registry using the CLR in debug mode, whereas when hosted in local intranet, NT security restricts you from accessing the registry, giving full access to registry in the NT security to the administrators and power users group. (More...)

How do I assign full trust to an XBAP application ?

  
The application crashes due to insufficient access to registry even if you have a local intranet certificate. The issue is, you get access to the registry using the CLR in debug mode, whereas when hosted in local intranet, NT security restricts you from accessing the registry, giving full access to registry in the NT security to the administrators and power users group. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


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