som of few questions - DBA - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

som of few questions - DBA

Author

Topic

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-06-25 : 04:44:35

1. what is the diffrent type of shrink :
a.shrink Database
b.shrink files
2.why we dont do shrink to the DATS?
3.give me example when we need to choose this option in RESTORE(why we need this option:
Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY)

thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-06-25 : 08:19:05

Homework questions? Interview questions?

2)
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx

3) As the message says, when you want to restore additional transaction logs.

--
Gail Shaw
SQL Server MVP

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-06-25 : 08:36:58

first of all thanks that you answer me/

no homework and no interview.
i learnd DBA, and read the moc ,i just want to understand that.

3) if you see the option RESTORE in managment studio,you can see in first option you have Additional transaction logs too.
the diffrent is between :RESTORE WITH RECOVERY AND NORECOVERY.

you can tell me please what is meaning RESTORE WITH RECOVERY AND NORECOVERY?

are you really MVP? (how do you get it?)

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-06-25 : 09:50:34

quote:
Originally posted by inbs

1. what is the diffrent type of shrink :
a.shrink Database
b.shrink files
2.why we dont do shrink to the DATS?
3.give me example when we need to choose this option in RESTORE(why we need this option:
Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY)

thanks

book online -> google -> forums....

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-06-25 : 13:06:59

quote:
Originally posted by inbs
you can tell me please what is meaning RESTORE WITH RECOVERY AND NORECOVERY?

Google is your friend. A quick search gets me these
http://msdn.microsoft.com/en-us/library/ms186858.aspx
There's a comparison of recovery and norecovery about half way down
http://msdn.microsoft.com/en-us/library/ms187495.aspx
How to restore a database
http://msdn.microsoft.com/en-us/library/ms189596.aspx
Restoring transaction log backups

quote:
are you really MVP? (how do you get it?)

If I wasn't, I wouldn't be claiming to be one.

It's an award from Microsoft for community involvement and technical knowledge

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources