Title | : | How to restore SQL Server 2005-2008 master database |
Lasting | : | 6.09 |
Date of publication | : | |
Views | : | 23 rb |
|
you can take server in single user mode by brGo to SQL Server Configuration Manager and click on SQL Server 2005 Services Click on desired SQL Server instance and right click go to properties On the Advance table enter param ‘-m;‘ before existing params in Startup Parameters boxbrbrMake sure that you entered semi-comma after -m Once that is completed, restart SQL Server services to take this in effect Once this is done, now you will be only able to connect SQL Server using sqlcmd Comment from : K J |
|
Alireza Aliabadi I was wondering can this be done if the msdb is from sql server 2000 and I have to transfer It on sql server 2008 Comment from : Marvin Mercado |
|
Hey! It makes sense, but 1st I couldn't start SQL Server Service as single user mode because I get an error, what it says: just SQL Server and a big X 2nd I can not start SQL Server Command Prompt, it says: Named Pipes Provider: Could not open a connection to SQL Server [2] etc I have installed SQL Server Express 2012 I'm new with SQL Server so I need some help here, please Comment from : mariposita3m0 |
|
thank youvery muchi show this video and solved my problem
and please post the video about migration (move database from Sql server 2005 to 2008) Comment from : monika p |
|
I am getting a blank Error Window wi jux X mark when typed C:Program FilesMicrosoft SQL ServerMSSQL10_50SQLEXPRESSMSSQLBinn>sqlserverexe -m -c
plse help me out!
Comment from : shashi kant |
|
The best way to teach someone onlinegreat work !!! Comment from : Sajal Bagchi |
|
Awesome Video Comment from : MyRockNow |
SQL | How to Upload / Restore a Database in SQL Server? РѕС‚ : Learn at Knowstar Download Full Episodes | The Most Watched videos of all time |
how to download and install sql server 2008 R2 step by step | download and install sql server 2008 РѕС‚ : Learning Talk Nadeem Download Full Episodes | The Most Watched videos of all time |
SQL Full Course In 10 Hours [2023] | SQL Tutorial For Beginners | SQL For Beginners | Edureka РѕС‚ : edureka! Download Full Episodes | The Most Watched videos of all time |
Microsoft Access SQL Tutorial. How to Use SQL With MS Access Databases. 5 Reasons to Learn SQL. РѕС‚ : Computer Learning Zone Download Full Episodes | The Most Watched videos of all time |
How to Install sql server 2005 on windows 7 РѕС‚ : BaqirAbbas Vlogs Download Full Episodes | The Most Watched videos of all time |
Installing Microsoft SQL Server 2005 Express Edition РѕС‚ : myjackiecat Download Full Episodes | The Most Watched videos of all time |
SQL Server 2005 Video Tutorial - 1 - Installing РѕС‚ : Wade Harvey Download Full Episodes | The Most Watched videos of all time |
Installing MS SQL Server 2005 SP3 Express Edition РѕС‚ : cartzlink Download Full Episodes | The Most Watched videos of all time |
Database Design Course - Learn how to design and plan a database for beginners РѕС‚ : freeCodeCamp.org Download Full Episodes | The Most Watched videos of all time |
SQL Tutorial - Full Database Course for Beginners РѕС‚ : freeCodeCamp.org Download Full Episodes | The Most Watched videos of all time |