5:34 PM
Bhavik Shah
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.
Posted in: SQL
4 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.
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