SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 LUN goes offline when shriking database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Alex2011
Starting Member

18 Posts

Posted - 06/07/2011 :  11:45:16  Show Profile  Reply with Quote
HI ALL,

I maintain a huge and fast-growing data to hold all our images/photos. Drive volume is 5.5 TB and 1.5 TB free space. Now I have an issue - whenever i shrink/backup the database, the LUN goes offline. Every time i have to ask our network guy to make it online. Does anybody know why this happened and how to fix it? thanks,

Alex

dinakar
Flowing Fount of Yak Knowledge

USA
2507 Posts

Posted - 06/07/2011 :  22:19:06  Show Profile  Visit dinakar's Homepage  Reply with Quote
what are the steps you are following?
On a similar note, you should NEVER shrink data files. Shrinking causes fragmentation and is almost guaranteed to affect performance.

why do you need to shrink?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

Alex2011
Starting Member

18 Posts

Posted - 06/08/2011 :  09:18:50  Show Profile  Reply with Quote
Thanks for your reply!

In Enterprise Manager, I checked the database files and saw the Current size is much bigger than the Space used so I think I should shrink the database. Please explain why I should never shrink the data files - I have to say I am not a DBA.

Scheduled database backups and loading more photos/images also made the LUN goes offline. Appreciate if you can provide some help.



quote:
Originally posted by dinakar

what are the steps you are following?
On a similar note, you should NEVER shrink data files. Shrinking causes fragmentation and is almost guaranteed to affect performance.

why do you need to shrink?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/


Edited by - Alex2011 on 06/08/2011 09:21:22
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 06/08/2011 :  09:27:36  Show Profile  Visit russell's Homepage  Reply with Quote
I'm betting you're filling the volume, causing it to go offline. Having this happen repeatedly may well eventually corrupt the database(s) on that volume.

Have your Network Admin check/monitor this, and probably extend the volume.
Go to Top of Page

Alex2011
Starting Member

18 Posts

Posted - 06/08/2011 :  11:29:40  Show Profile  Reply with Quote
But it has enough free space (1.5TB). The LUN goes offline even when I tried to load 200GB images/photos.




quote:
Originally posted by russell

I'm betting you're filling the volume, causing it to go offline. Having this happen repeatedly may well eventually corrupt the database(s) on that volume.

Have your Network Admin check/monitor this, and probably extend the volume.

Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 06/08/2011 :  11:45:33  Show Profile  Visit russell's Homepage  Reply with Quote
Your SAN/Network admin needs to fix this. I've only seen this happen when volume filled up. Fixed by extending the volume.

Also, make sure any SAN tools that dynamically reorganize volumes is turned off. This isn't uncommon when thin provisioning volumes, but isn't acceptable for database servers or exchange servers (works great for file servers).
Go to Top of Page

dinakar
Flowing Fount of Yak Knowledge

USA
2507 Posts

Posted - 06/08/2011 :  14:16:37  Show Profile  Visit dinakar's Homepage  Reply with Quote
why you should not shrink your database - http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.45 seconds. Powered By: Snitz Forums 2000