Brandie Tarvin (11/6/2012)

---

For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

Anyone have any suggestions for me to...

Arthur Kirchner (11/6/2012)

---

It its really annoying, how the log shrinking is solved in SQL Server 2008.

Sometimes the is simply a need to quickly shink the log file without being able...

unlimited growth is ok when your database growth is fairly stable, again when you are keeping an eye on the database itself just check the free space on the drive.

size...

sqladmin 45377 (11/4/2012)

---

Thanks so much for the info, George. I'll uncheck that shrink option and keep an eye on the size.

I'll have to brush up on how to best...

the shrink will be running but is probably unable to acheive much on the data file as your database is unlikely to have much free space, the log file could...

shrinking does not break the log chain.

Make the shrink a one off operation, do not repeatedly shrink it. Be sure first of all the log does not need to be...

sounds like aliases have been set up

yogi123 (10/16/2012)

---

Ok, so that means

if i set up Initial size to 119.644 MB. then...

correct. Restricted size needs to be >= to the size you want to increase to.

USE master;

GO

ALTER DATABASE yourdb

MODIFY FILE

(NAME = logical file name,

SIZE = size you wantMB);

GO

see http://technet.microsoft.com/en-us/library/bb522469(v=sql.100).aspx

you can also do it via SSMS, right click...

you will need to record the users in database on server B before you restore over it. There is a script here [/url]to do that, read the discussion attached as...

I think you need to enable remote SSIS connections via DCOM. see

http://msdn.microsoft.com/en-us/library/aa337083(v=sql.100).aspx

backing up to local disk should be quicker.

Experiment with striping the backups, you could see improvements, or if you run your database backups consecutively, run some in parallel to try...

patch the passive node, then failover to it. On failover the patching process for that node is completed as SQL goes into update script mode as it comes up. That...

http://support.microsoft.com/kb/2740411