Problems activating your account? Send notification email to: admin@post4vps.com
Host4Fun Budget VPS Hosting
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to Backup MSSQL Database From SQL Server Management Studio?
#1
In order to take a backup MSSQL database, please follow the below steps:
Step-1: Connect to MSSQL Management studio.
Step-2: Once you are connected to Microsoft SQL Server Database Engine, at the left-hand side in Object Explorer pane, click the SQL server name to expand the server tree.
Step-3: Expand Databases and right-click on the database, select Tasks and click Backup. This will open up Backup-database window.
Step-4: In the Backup type list box select Full, for Backup component, click Database.
Step-5: Enter the name for the backup set or accept the suggested default backup set name.
Step-6: Enter Description of the backup set (optional).
Step-7: Choose the type of backup destination to Disk and click Add. Now select the destination where you want to store the database.
Step-8: Once you select the backup destination, click Ok.

Step-9: Make sure that your chosen backup destination is listed in destination box and click Ok.

Step-10: Navigate to backup destination and verify the backup file.

That’s it.
You can also refer to this URL.
Reply
#2
Hmm, may I ask a little!
What is the difference from mysql with mssql
I am sleeping !
Reply
#3
(01-12-2019, 02:01 AM)chanalku91 Wrote:  Hmm, may I ask a little!
What is the difference from mysql with mssql
Microsoft will feel hurt by your question. Tongue

MySQL is open source and MSSQL paid as it belongs to Microsoft. The MS stands for Microsoft.

You can find more info here:
https://medium.com/@mindfiresolutions.us...b537e474be

Quote:Both MySQL and MS SQL Server are widely used enterprise database systems. MySQL is an open source RDBMS, whereas SQL Server is a Microsoft product. Microsoft allows enterprises to choose from several editions of SQL Server according to their needs and budget. But the smart programmers always keep in mind the major differences between MySQL and MS SQL Server to pick the right RDBMS for their project.
[Image: 4ax8Kok.png]
Thank you to Post4VPS and VirMach for my super fast VPS 9!
- DH Blog




Reply
#4
Haha, it's better for them to get hurt, because their software has been cracked, than they are hurt by silly questions Cool
I am sleeping !
Reply
#5
What software has been cracked? What are you even talking about, @chanalku91? In case of piracy - read the forum rules.

MSSQL has a free version called MSSQL Express that is limited to max. 4 CPU cores, 1 GB of RAM usage and 10 GB of size. Free of charge.


MSSQL Management Studio is a GUI to manage MSSQL database by the way. It is what Heidi, phpmyAdmin or Adminer is to MySQL/MariaDB.
With best regards
Hidden Refuge
IT specialist for system integration

Reply
#6
lol. i think she means mssql is less secure and more prone to security vulnerabilities that lend to easier hacking.
or may be she thinks Microsoft should only get hurt if their version of sql gets hacked and not for asking questing about it.
I always try to do an elaborate table of alternatives in my mind when I am reading posts from that guy. really cryptic.

may be translator would do a far better job if she/he wrote clearly in native language.
Thanks to cubedata.net and post4vps.com for my awesome vps8.
Reply
 


Possibly Related Threads...
Thread Author Replies Views Last Post
  How to move a phpBB forum from one server to another - the easy way! deanhills 7 398 02-16-2019, 10:01 PM
Last Post: rudra
Thumbs Up How to optimize Apache web server? harry_v 9 420 02-07-2019, 11:56 AM
Last Post: humanpuff69
  How to change minecraft server version through control panel Honey 0 219 12-11-2018, 02:52 PM
Last Post: Honey
  Quickest way to backup and restore WordPress Sites deanhills 10 1,099 11-12-2018, 06:12 PM
Last Post: NomadicSingularityArray
  Install MTA:SA Server with single command(Auto Installer) Lampard 11 2,784 09-18-2018, 07:56 AM
Last Post: AmirGT

Forum Jump:


Users browsing this thread: 1 Guest(s)

Sponsors: VirMach - Host4Fun - CubeData - Evolution-Host - HostDare - SSDBlaze - VPSlices - Abc-Hosters - Hyper Expert - Shadow Hosting - Bladenode - HostDoc - Hostlease


About Post4VPS

Post4VPS is a forum/destiny where you can Delploy Your Free VPSs just by the Power of Posts.

We Provide VPSs of many locations like Germany,US,Canada,France,London,etc.

We also Provide VPSs of Both Linux and Windows OS.