Total Pageviews


Database BackUp and Restore Script

For .Net developer a very common task is to take reguler backup and restore of SQL Server Database. Most of the time developer does that thru UI of Sql Server Management Studio. It is acully nice to know the Scripts which we can run and take backup and restore easily.

       To BackUp :-        
     BACKUP DATABASE [DatabaseName] TO DISK = 'C:\FileName.bak' WITH FORMAT
       To Restore :-
           RESTORE DATABASE [DatabaseName] FROM DISK = 'C:\FileName.bak'

Also when ever you do any database opration thru UI of Sql Server Management Studio you can always have look to the Script behind that opration. Its good practise to look at the script run by Sql Server to do any database realted opration.


vikram kumar said...

Insert into tablename(columnname)
select columnname from sourcetable

Rajah Mcguire said...

A database from more recent edition can not be renewed on newer version or SQL Hosting server.

link said...

I shared a link to your blog with my friend programistom. He said that you are an incredibly wonderful person skilled in Ivashov blog is very useful and interesting.

Anonymous said...

Advertising is your main tool to have the business ready to go. Actually, everybody is busy in their company marketing over the World Wide Web. Unfortunately, online company is scammed with scammers. On occasion the provider hires you freelance, or occasionally it is a site designer which orders the copy google At an identical time, if you decide on the most suitable company having excellent reviews and reputation, you will enjoy well composed works.

Wilhelm Duncan said...

It’s a nice tips for a newbie user, I think. Because after using it for couple month or so, you will be ***king expert in it. However, it is true that from begging you will fail a lot on the things as you wrote here. The same thing in study and review of can help you with that a bit.

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Affiliate Network Reviews