As someone who is just starting a new career in IT, I am constantly looking for insightful articles about the industry. This was not one of them.
I am just finishing up my SQL SERVER 2000 certification for an MCSD and was hoping to find a few choice nuggets of information NOT presented in any of the texts from which I am studying.
The article published here is nothing more than a rudimentary re-hash of Chapters 8 and 9 in the 70-228 training kit. I was hoping (expecting?) more, perhaps even a mini-case study to exemplify the topics presented in material.
Hopefully, future articles will be more useful and offer more depth.
Discussion on:
View:
Show:
The majority of people reading this article have not done the course. Think about it..
SQL server is a GUI based database in which situation we can say that enterprise manager is not there and we take backup by using transact sql. I want to know the situation/scene where enterprise manager is not.
SQL Server is a database.
Enterprise manager is the GUI that interacts with the database. All enterprise manager does, is translate menu selections from the user, and runs the appropriate stored procedure (ie. T-SQL).
Not everyone has Enterprise Manager and therefore the need to learn underlying code is a necessity for some people.
Cheers,
Andrew
Enterprise manager is the GUI that interacts with the database. All enterprise manager does, is translate menu selections from the user, and runs the appropriate stored procedure (ie. T-SQL).
Not everyone has Enterprise Manager and therefore the need to learn underlying code is a necessity for some people.
Cheers,
Andrew
Like one of the other respondents, I also would like to see more elaboration in the articles. Granted, the step-by-step "how-to" instruction is a good visual/textual introduction/review. However, where appropriate, I would also like suggestions on "best practices" and cautionary guidance, e.g., among the three "Recovery State" options, what are the implications or consequences of each option. Unlike the other respondent, I appreciate being shown how to do the same task(s) using T-SQL. If you did all your tasks exclusively in Enterprise Manager, you would never learn SQL logic.
I have one SQL Server which backsup my database onto a differnt machine. It performs full database backup every night at 2.00 am, performs diff. backup every 4 hrs. starting from 2:30 am and transactional log backup every 20 minutes
starting from 3:00 am.
Since the backup performs on a different machine, it does not show the list of backups in that machine.
When I restore the full backup of 2.00 am midnight in that machine, the full backup restores successfully. When i restore the last differential backup it gives an error. I am not able to understand the problem.
However, if the backups are performed on the same machine where the database resides, then all restorations (full,diff,transactional) work fine.
Pls. guide me.
starting from 3:00 am.
Since the backup performs on a different machine, it does not show the list of backups in that machine.
When I restore the full backup of 2.00 am midnight in that machine, the full backup restores successfully. When i restore the last differential backup it gives an error. I am not able to understand the problem.
However, if the backups are performed on the same machine where the database resides, then all restorations (full,diff,transactional) work fine.
Pls. guide me.
When we take back up of Transaction log,does it internally create files.As in the article while restoring you have given the syntax as
Restore Database pubs
from disk =''
with norecovery
and then second time you have written
with file=2,norecovery
So i have two question
1)Is in the syntax, instead of writing "Restoring Log","restoring Database" is there so is it wrong.
2)When we take back of transaction log ,Is some internal file numbering is there,so that we can distinguish themby file number.
Regards,
Pankaj Jain
Restore Database pubs
from disk =''
with norecovery
and then second time you have written
with file=2,norecovery
So i have two question
1)Is in the syntax, instead of writing "Restoring Log","restoring Database" is there so is it wrong.
2)When we take back of transaction log ,Is some internal file numbering is there,so that we can distinguish themby file number.
Regards,
Pankaj Jain
how about restoring a .dat file from ms sql 6.0
I agree with Steven in keeping the article simple and that's why it covers basic ways to restore a database backup like using using Management Studio.
I found this tool http://sqlbackupandftp.com/restore/ to perform simple backup restoration. It can restore full backups from compressed and regular .BAK files.
I the same web site there is a backup tool http://sqlbackupandftp.com/ that creates full and differential backups and lets you compress and save them in remote sites.
I found this tool http://sqlbackupandftp.com/restore/ to perform simple backup restoration. It can restore full backups from compressed and regular .BAK files.
I the same web site there is a backup tool http://sqlbackupandftp.com/ that creates full and differential backups and lets you compress and save them in remote sites.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
