Microsoft SQL Server Release Services

( http://blogs.msdn.com/b/sqlreleaseservices/ )

has missed the last release of a Cumulative Update for both SQL 2008 R2 (Dec) and SQL 2008 (this month)....

robgilbie (1/12/2012)

---

For example in 2008 to append the machine name, date and time to a backup file name the script would look like this:

backup database MSDB to disk = N'c:\sql...

I don't prefer this method because the logins are disabled, and their passwords are scrambled. The "sp_help_revlogin" method avoids those two issues.

If that's...

A deer rifle, and a generator.

Merry Christmas to all. Remember the Reason!

Thanks. I have tried running as SERVERNAME\Administrator, and the results are the same.

I have extracted the SP1 setup file to a folder by running SQLServer2008R2SP1-KB2528583-x86-ENU.exe -extract. Now I can go direct to setup.exe and run it.

I see a command window blink, then...

OomBoom (9/19/2011)

---

Hi

I would suggest login on to the server as the local administrator. Make sure the service accounts has the correct rights. The only place I have seen this before...

1) "It depends".

2) "No", probably.

3) ModelID was "probably" a typo.

Both the actual table structure and the data contents were unknown. I'm fairly sure I could provide schemas and data sets,...

That's a nice, concise page. I have several of these bookmarked but this one is quick to...

So, does he think he's being punished instead of honored?

Jeffrey Williams-493691 (3/21/2011)

---

This is not about the server having access, but the login matching the domain account. If the domain account is all uppercase, and the login is not...

Craig - many thanks!

I'll be saving and studying the info you provided.

FWIW, the 3rd party software vendor now tells me they are familiar with this behavior.

He asked me...

Craig Farrell (3/2/2011)

---

:blink: Do you have Service Broker active on this database? Check...

Robert klimes (3/2/2011)

---

This is a log shot but try running this to see if any system objects are taking up the space. system objects do not show up on the...

Mon diff = 200 MB

Tue diff = 4.6 GB

Today's log backups - idling 58k, between 10 and 14 MB during business...