Another way

SELECT

CONVERT(DATETIME,

CONVERT(VARCHAR(10),

CONVERT(DATETIME,

ABS(CHECKSUM(NEWID()))%(780)+(33968)

)

,120)

+'T'+

CONVERT(VARCHAR(12),

CONVERT(TIME,

DATEADD(MILLISECOND,ABS(CHECKSUM(NEWID()))%86400000 ,'00:00')

)

)

)

Either or.

Personally, I would never append a backup to an existing file. I would always create a new file for each backup, that way if corruption happens on day...

The closest your going to get with a maintenance plan is to set the expiry to 1 day, to expire the media set.

The alternative would be to backup to a...

Are you backing up each day to the same file?

If so do you never need to go back more than the current backup?

Format will write new header information so any...

Pudding

Luis Cazares (10/19/2015)

---

This can be done without temp tables as there's a single row returned.

Unless I'm missing something, here's my suggestion.

--Dynamic Pivot

DECLARE @sql NVARCHAR(MAX);

/*

STUFF is used...

Pie

Post (HTTP request)

Do all the servers in the cluster have enough space to allow all secondaries to grow also?

Could one of the other servers E drives only have 50GB free for example?

Sounds like you need a double split dynamic pivot

You will need the dbo.delimitedsplit8k function which can be found in my signature on the "String Splitter Link"

Then you will need to...

Ed Wagner (10/19/2015)

---

anthony.green (10/19/2015)

---

Ed Wagner (10/16/2015)

---

anthony.green (10/16/2015)

---

Ed Wagner (10/16/2015)

---

anthony.green (10/16/2015)

---

Road (mmmm...

Are the files in the primary filegroup allowed to grow? If so whats the current filesizes, growth rate and is there enough storage to auto grow the database...

Yes I could write a stored proc, but it wont answer your problem.

CREATE PROCEDURE MyProc

AS

BEGIN

SELECT * FROM [dbo].[Transaction]

END

GO

I don't know what your column types are, I don't know what your...

There are no attachments on any of your posts.

Images are no good, we need the code which is in a easily consumable format, like the code I posted earlier

Please read this link http://www.sqlservercentral.com/articles/Best+Practices/61537/

Could you then re-post the table definition, sample data and expected outcome?