Please you can help me, why when I install SQL server 2012 not appear in SQL Managment Studio. While I installing all this files 1-SQL Managment Studio - Complete 2- SSDTBI_VS2012_x64_ENU 3- SQLEXPR_x64_ENU 4- SQLEXPRADV_x64_ENU 5- SQLEXPRWT_x64_ENU 6- SqlLocalDB Thanx for all you cooperation
+Mohammed Ahmed Based on the information, I'm not sure. If you're connecting to your servers through SSMS, you should be able to see SQL Agent. Now, it might not be running. You may have to start it if it's not set to auto-start. For more and better help around this, I'd suggest posting your question at SQLServerCentral.com.
Please Can you Help me , when i make restore for database from backup to partition D , i field but when restore to C i success , although i use administrator and have full permission on D to create file this was in sql 2012 on win server 2012 , what the solution ?
+Tarek K It really depends on the error. If the error is around permissions, it's likely that the account that the server is running on doesn't have permission. It's not a question of your permission. The SQL Server service must have access to the drive in order to use it.
I don't know php, so I can't comment on the exact code necessary there. However, the backup command is going to be the same for SQL Server. It won't change. it will still be BACKUP DATABASE X... Just issued through php instead of through some other mechanism.
You are an awesome teacher. Thank you this should lay the foundation for backups and restores just fine.
Roxanne Reyes Thanks. Very kind words.
Thanks a ton !
The first 8 minutes explained how our backup (bak) file was sometimes getting almost twice in size !
amazing.. straightforward and simple,
thank you very much for sharing
Thank you. Glad it was helpful.
Hi great clip as usual. What InteliSense /options are you using in Management Studio?
Ah, well, that's not Intellisense. I have that turned off. What you're seeing is Red Gate's SQL Prompt.
Grant Fritchey And that's not free :(.
Yep. Not free. Sorry.
What would be the problem if I set the last LOG to RECOVERY as oppose to Restoring the DB again in the final step?
cool :) more power with TSQL jobs rather than using maintenance plans.
thank you for this great Video
Thank y for this Good Video .
Please you can help me, why when I install SQL server 2012 not appear in SQL Managment Studio.
While I installing all this files
1-SQL Managment Studio - Complete
2- SSDTBI_VS2012_x64_ENU
3- SQLEXPR_x64_ENU
4- SQLEXPRADV_x64_ENU
5- SQLEXPRWT_x64_ENU
6- SqlLocalDB
Thanx for all you cooperation
+Mohammed Ahmed Based on the information, I'm not sure. If you're connecting to your servers through SSMS, you should be able to see SQL Agent. Now, it might not be running. You may have to start it if it's not set to auto-start.
For more and better help around this, I'd suggest posting your question at SQLServerCentral.com.
Please Can you Help me , when i make restore for database from backup to partition D , i field but when restore to C i success , although i use administrator and have full permission on D to create file
this was in sql 2012 on win server 2012 , what the solution ?
+Tarek K It really depends on the error. If the error is around permissions, it's likely that the account that the server is running on doesn't have permission. It's not a question of your permission. The SQL Server service must have access to the drive in order to use it.
no word you are rock
Thanks, just trying to help out.
awesome
How to backup Database using php ?
I don't know php, so I can't comment on the exact code necessary there. However, the backup command is going to be the same for SQL Server. It won't change. it will still be BACKUP DATABASE X... Just issued through php instead of through some other mechanism.