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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

Dump a Job from one server to another server

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
 
I have a job running on production server, i need to replicate the same job to QA server. I dont have access to see Jobs in production server, could you please help me in replicating the job to my QA server. Please provide me a command which dumps the job from one server to another... EXEC   dbo.sp_add_jobserver @job_name = N'JobName', @server_name = N'QAServer' I am running this command on production server, i got errors saying that The specified @job_name doesnt exist Please help meSandeep...


View Complete Post


More Related Resource Links

DUMP Server -- Configuration

  

Hi all

I am Planning to Impliment Backup servers(Central SAN Server) in our Organization,I am started looking into sites I did not any information about Backups servers.

I assumed some points how my Storage Servers is going to be,Please some give some value added to my points and best configuration for Storage server.

1.Backup server is a Central SAN Server and called as SAN Server or DUM Server or as File Server.

2.Central Server should be accessible to all Database servers with copy only permissions.

3.Central SAN Server should have GOTO_TAPE, NOGOTO_TAPE folders and GOTO_TAPE, NONGOTO folder should have sub folder for each Database Server.

4.Central SAN Server should have a TAPE drive to take backups from GOTO_TAPE folder.

5.Usually  seven tape are required take backups from Server, Names of the Tape are
Monday,Tuesday,Wednesday,Thursday,Friday,Saturday and Sunday.

7.Seven tape are used by weekly rotation basis

 

Thank in Advance


SNIVAS

DUMP Server -- Configuration

  

Hi all

I am Planning to Impliment Backup servers(Central SAN Server) in our Organization,I am started looking into sites I did not any information about Backups servers.

I assumed some points how my Storage Servers is going to be,Please some give some value added to my points and best configuration for Storage server.

1.Backup server is a Central SAN Server and called as SAN Server or DUM Server or as File Server.

2.Central Server should be accessible to all Database servers with copy only permissions.

3.Central SAN Server should have GOTO_TAPE, NOGOTO_TAPE folders and GOTO_TAPE, NONGOTO folder should have sub folder for each Database Server.

4.Central SAN Server should have a TAPE drive to take backups from GOTO_TAPE folder.

5.Usually  seven tape are required take backups from Server, Names of the Tape are
Monday,Tuesday,Wednesday,Thursday,Friday,Saturday and Sunday.

7.Seven tape are used by weekly rotation basis

 

Thank in Advance


SNIVAS

SQL Server 2008 Dump Transaction

  

I used SQL Server 2005 before and used "DUMP TRANSACTION ... WITH NO_LOG" statement, i tried to do same  thing in SQL Server 2008 and it doesn't work. How can i use it in SQL Server 2008?


Calling Procedure from ADO.NET with a Name That Starts with Sys Causes SQL Server Stack Dump

  

After the better part of 5 hours, I finally figured out why I was getting this SqlException:  {"A severe error occurred on the current command.  The results, if any, should be discarded.\r\nA severe error occurred on the current command.  The results, if any, should be discarded."}

If you call a stored procedure that *starts* with Sys (e.g. dbo.SystemConfigurationUpdate, dbo.SystolicPatientRecords, or SyscoFoodsPurchase) and at least one specified variable is a Table Value Parameter, SQL Server 2008 stack dumps (below).

If you add anything to the front of the Sys, it works fine (e.g. mSysConfigUpdate or mSys).

 

--- STACK DUMP ---

***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0037.txt

SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

* *******************************************************************************

*

* BEGIN STACK DUMP:

*   11/02/10 10:25:14 spid 54

*

*

*   Exception Address = 000000000105A8B0 Module(sqlservr+00000000002DA8B0)

*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION

*   Access Violation occu

Got sql dump with pur virtual function call error and server got restarted.

  
Hi, I got an sql dump created with the following message: Couldn't figure out the virtual function call error... Can someone help with this. A part of dump msg is added for your reference. Memory MemoryLoad = 91% Total Physical = 32763 MB Available Physical = 2885 MB Total Page File = 64210 MB Available Page File = 35487 MB Total Virtual = 8388607 MB Available Virtual = 8348824 MB **Dump thread - spid = 149, PSS = 0x000000022BA43A80, EC = 0x000000022BA43A90 ***Stack Dump being sent to Y:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 11/12/10 19:48:00 spid 149 * * Location: purecall.cpp:51 * Expression: !"purecall" * SPID: 149 * Process ID: 4952 * Description: Pure virtual function call

Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0026.txt

  
Hello all,

I found on one of our server restart automatically after show stack dum error.
some part of log is given below any help will be appreciate.


Memory                              
MemoryLoad = 46%                    
Total Physical = 4094 MB            
Available Physical = 2172 MB        
Total Page File = 5971 MB           
Available Page File = 4226 MB       
Total Virtual = 2047 MB             
Available Virtual = 306 MB          
**Dump thread - spid = 51, PSS = 0x3D859580, EC = 0x3D859588                                                    
***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0026.txt             
* *******************************************************************************                               
*                                                                                                               
* BEGIN STACK DUMP:                                                                                             
*   07/21/09 11:05:01 spid 51                                                                                   
*                                                                                                               
* e

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

  
A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:
Categories: 
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