Detach and Attach a Database in SQL Server

  Рет қаралды 88,323

SQL with Manoj

SQL with Manoj

Күн бұрын

Пікірлер: 29
@FahdJeddah
@FahdJeddah 3 жыл бұрын
Thank you , Spend few hours looking for soultion until i reach your video and foloow your steps and its working ... Thank you
@aslidemir1995
@aslidemir1995 Жыл бұрын
Excellent explanation, thanks!
@ErsinGokay
@ErsinGokay 5 жыл бұрын
excellent demo, thank you
@sricharan5918
@sricharan5918 7 жыл бұрын
super explained sir. keep posting please
@asusgamer5556
@asusgamer5556 6 жыл бұрын
Im going to try this out!! Thank you Manoj for the video
@wrestlingarchitect4399
@wrestlingarchitect4399 5 жыл бұрын
This guy should get 1 Mil subs in a year's time!
@wrestlingarchitect4399
@wrestlingarchitect4399 5 жыл бұрын
Brilliant Video. Great Stuff!!
@bushallowance
@bushallowance 6 жыл бұрын
it is very helpful thanks
@nazeenak9522
@nazeenak9522 2 жыл бұрын
THANK YOU
@Benmaluco9
@Benmaluco9 6 жыл бұрын
Obrigado.
@rizwanali2004in
@rizwanali2004in 6 жыл бұрын
I need a help regarding SQL Server database, Previous day my database has been hacked , Now I got error Ally files have been Encrypted, do u have any solution?
@rohan7387244002
@rohan7387244002 6 жыл бұрын
i have facing the error like [ Unable to open the physical file "G:\ROHAN ABI\Photo ewdatabase.mdf". Operating system error 5: "5(Access is denied.)".] what is this sir
@ManojPandeyManub22
@ManojPandeyManub22 6 жыл бұрын
This means that the account which is running SQL service does not have access to this location. open services.msc and see what account SQL Server service is running. Either change that account with an admin account, or provide that account access to this folder. Check this blog post for more info: sqlwithmanoj.com/2016/10/25/sql-error-unable-to-open-the-physical-file-operating-system-error-5-5access-is-denied/
@rohan7387244002
@rohan7387244002 6 жыл бұрын
now its working after giving full control to folder thank u.. please make video on :-- managing configuration, disaster recovery,database security and troubleshooting ,
@rohan7387244002
@rohan7387244002 6 жыл бұрын
also investigation and troubleshooting database corruption/recovery scenarios
@ManojPandeyManub22
@ManojPandeyManub22 6 жыл бұрын
sure, please subscribe... will make whenever I get time :)
@jatinkhunt3885
@jatinkhunt3885 6 жыл бұрын
Helle sir ,Mere ko 2 computer me same data base use karna hai using lan in MS SQL server to kese kare aap muje bata sakte hai??
@MohamedOsman-xk3xe
@MohamedOsman-xk3xe 7 жыл бұрын
thanks tecaher thanks i get manay advantage for this video
@jingtingong6177
@jingtingong6177 3 жыл бұрын
after attach the sql is ok, but how we know it is same functioning as database before dettach?
@mmmmm6941
@mmmmm6941 5 жыл бұрын
Sir please upload more videos. Also one request can you show how to configure AlwaysOn please?
@sureshht
@sureshht 5 жыл бұрын
You copied files to new location. So, old location still has these files. Can we cut and paste the files?
@SQLwithManoj
@SQLwithManoj 5 жыл бұрын
yes, you can cut & paste.
@rufusvankpanah8551
@rufusvankpanah8551 4 жыл бұрын
I detached my database without reattaching it and mistakenly closed ssms. Now, I can't log back in. Pls any idea?
@vteklab4068
@vteklab4068 3 жыл бұрын
First thanks for making such great series in really easy explanation. When i am trying to attach in new server, its saying (Read only), please help if any option i can take a look on. Thanks
@samjunker4862
@samjunker4862 6 жыл бұрын
u the best :)
@manashbehera7682
@manashbehera7682 5 жыл бұрын
i am in bangalore, plzzzzzz plzzzzz sir help me
How to Backup and Restore a Database in SQL Express
12:19
Sean MacKenzie Data Engineering
Рет қаралды 1,3 М.
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 148 МЛН
路飞做的坏事被拆穿了 #路飞#海贼王
00:41
路飞与唐舞桐
Рет қаралды 26 МЛН
Don’t Choose The Wrong Box 😱
00:41
Topper Guild
Рет қаралды 54 МЛН
Quando eu quero Sushi (sem desperdiçar) 🍣
00:26
Los Wagners
Рет қаралды 13 МЛН
SQL Server Log File is HUGE!
11:18
Kevin Hill
Рет қаралды 109 М.
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Database Star
Рет қаралды 90 М.
SQL Server Statistics Basics - Part 1 (by Amit Bansal)
21:01
SQLMaestros
Рет қаралды 38 М.
SQL Server DBA Tutorial 31- How to Attach and Detach Databases
12:32
TechBrothersIT
Рет қаралды 56 М.
SQL Server Management Studio Tips & Tricks
13:25
SQLMaestros
Рет қаралды 15 М.
Microservices with Databases can be challenging...
20:52
Software Developer Diaries
Рет қаралды 107 М.
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 148 МЛН