This has a pretty good outline of steps you can try to follow.

https://www.mssqltips.com/sqlservertip/2710/steps-to-clean-up

Sue

Take a look at the following article - Managing Database Data Usage With Custom Space Alerts

http://www.sqlservercentral.com/articles/alerts/89885/

Sue

psred (9/29/2016)

---

Yeah i did that its not working that way. So the case here is that the initial file is set to 25gb for each of 12 files and autogrowth...

You need...

Job schedules are associated with Jobs themselves, not job steps. So it sounds like what you want is different jobs for each of the packages.

Sue

nautiyal.jalaj (9/29/2016)

---

Hello All,

I am new to database. I created a sql job which takes backup of database once in a week. But its been failing. I receive below mentioned...

I wouldn't make shrinking databases a part of regular maintenance. It causes fragmentation and can waste resources. It's generally not a recommended practice.

Sue

There is a known issue when restoring to standby. You might want to check the CU for 2014 in the KB article to see if you have that in place....

mw112009 (9/28/2016)

---

Sue_H:

I know how to do the XL Query stuff.

Unfortunately that still leaves us having to do further scanning to get the name of the table etc.

I have pasted a...

coreyjbaum (9/28/2016)

---

I have a single data file thats over 5tb in size and id like to split it up into multiple files across multiple drives. Whats the best way to...

mw112009 (9/28/2016)

---

Select top 100 * FROM ReportServer.dbo.Catalog

I like to know whether it is possible to write a SQL statement that will return

1. Report name, 2. sp_name (...

SQL Galaxy (9/28/2016)

---

Will it possible to download for PSSDIAG Configuration manager tool from Microsoft site?

Pl. provide suitable links, URLS. I tried as following setup but not available in 64 bit...

Ray K (9/27/2016)

---

Apologies for the stupid question -- where do I go to see if a SQL Server instance has an <i>existing</i> maintenance plan? Strangely, I haven't been able...

Must...

It's Oracle so it doesn't matter 🙂 See the original post, Oracle.

Sue