SQL SERVER Backup & restore database

  • backup database TestDB to disk = 'E:\testdb.bak' with stats = 10,password ='elshan'
  • http://www.mssqltips.com/sqlservertip/1849/backup-and-restore-sql-server-databases-programmatically-with-smo/ 

Comments

Post a Comment

Popular posts from this blog

Brother printer password reset using telnet

Image
  Login into printer using telnet. telnet 10.1.0.110 Enter default telnet password as 'access' . Press enter for the username or you can use admin or what ever username.  Type this command to reset the password SET PASSWORD abc123 New password will be abc123 .    Clear the web password of  MFC-8510DN  Note : when you change the password this will change the both web and telnet password. If you just need to reset the password enter SET PASSWORD. and hit enter key without password. That will reset the web login password and also it will automatically change the telnetpassword back to 'access'
Read more....

How to adjust the brightness in Samsung 19" SyncMaster SA100 LED monitor?

Image
METHOD ONE (I) 1. GOTO this site. http://www.samsung.com/us/consumer/learningresources/monitor/magetune/pop_download.html 2.download suitable version with our OS . me use windows7 then i choose ex :  http://www.samsung.com/us/consumer/learningresources/monitor/download/MagicTunePremium_Win7_WinVista_32bit_3.2.2.zip 3.run the program.if you are using laptop to use this LED monitor as secondary display first time this program may be not work.then drag that program into your secondary monitor display area and then click image menu. 4.Any questions please ask me. SECOND METHOD (II) Hold power button 8 - 10 seconds then monitor adjust automatically. THIRD METHOD (III) (STILL BETA VERSION RELEASED) You can download my small program [Open source] to adjust monitor brightness (dual monitor supported) from below link [Available as a source code and binary both] http://freevbs.blogspot.com/p/computer.html
Read more....

ASP.NET Server Controls Tutorial

Image
In this tutorial, you will learn how to build an ASP.NET server control by creating a Hello World Control. Along the way, we'll review the fundamental process of server control development from scratch. Creating a Custom Control Project First, we need to create a new class library project to hold our custom controls. By creating the custom control in a separate class library, we can compile the project into a separate DLL and use the custom control in any application that requires it. Open your ASP.NET project with Visual Studio or Visual Web Developer. In Solution Explorer, right click the solution name, and select Add New Project from the context menu. In the Add New Project dialog box, choose the project type to be a Web project, and select ASP.NET Server Control as the template, like so:
Read more....