Ok, no worries. Is the DB being added via GUI or T-SQL script or other?

Hi,

What Edition (e.g. Enterprise/Standard/BI/Web/Developer/Express) is each part?

Are you seeing this message when connecting to the RS databases via Reporting Services Config Manager and/or trying as a datasource for a report?

Thanks

Can you try creating the user's AD account as a login then granting those SQL rights directly to that login rather than through the group?

For SQL2000 you'll need to write a T-SQL query that calls DBCC SHOWCONTIG & probably do some modifications to get it into the same format as data returned from the...

Brandie Tarvin (1/20/2015)

---

Gazareth (1/20/2015)

---

I use a powershell script (happy to share if you want to try it) to grab weekly db/filesizes and store them in a db table but obviously...

It thought it should be checking the db itself is online. MS's documentation seems to suggest it's at the instance level though.

How often I don't know but the PARTNER TIMEOUT...

If it's not permissions, could the job be jumping onto the next step before the .exe has finished, i.e. before the csv file has been created?

Not sure at what point...

Oh, forgot - autogrowth events can be found in the default trace so you might be able to get some quick info on growth rates & frequency there, or setup...

Don't use % growth 🙂

This could well be causing the large amount of free space you're seeing. Index maintenance, archiving, data removal can also leave large amounts of free...

If you can expand on what rules would govern the number of spaces required we might be able to come up with a case statement that'll satisfy them.

Hi Mark,

Try wrapping the substring with a replace (CHAR(9) = TAB):

REPLACE(

SUBSTRING([definition],

LEN(LEFT([definition], CHARINDEX('/*', [definition]))) - 1,

LEN(LEFT([definition], CHARINDEX('*/', [definition]))) - LEN(LEFT([definition], CHARINDEX('/*', [definition]))) +3),

CHAR(9), ' ') -- four spaces,...

I waited!

After a while the errors resolved and I could see all the data in the target database. Very odd.

So, after further investigation, looks like the distribution agent at the subscriber is trying to read data out of the snapshot files before they've finished copying!

It's a terrible idea 🙂

There's no guarantee that copying mdf & ldf results in a consistent backup - it almost certainly won't.

How often would the files be copied? There won't...

New Born DBA (12/12/2014)

---

Gazareth (12/12/2014)

---

New Born DBA (12/12/2014)

---

Gazareth (12/12/2014)

---

Comparing the backup_size and compressed_backup_size fields in msdb.dbo.backupset table should tell you how much compression, if any, took place.

Which version & edition...