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 :-
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.
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.
5 comments:
Insert into tablename(columnname)
select columnname from sourcetable
A database from more recent edition can not be renewed on newer version or SQL Hosting server.
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.
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. http://google.com/
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 Essayontime.com can help you with that a bit.
Post a Comment