Technical Article

Check Full Recovery DBs Have Tran Log Backups

A quick procedure to check which full recovery databases have not had a tran log backup in the given period (default is 7 days). This could mean that the recovery mode might need changing or the transaction log backup jobs need investigating.

3.71 (7)

You rated this post out of 5. Change rating

2011-09-22 (first published: )

1,705 reads

Technical Article

sp_displaylogin - sybase style

this procedure takes a sql login name and returns information about the login.anyone who knows Sybase will recognise the name and layout. use :- exec sp_displaylogin 'loginname' to get login information returned.this procedure has been tested on SQL Server 2005 sp2any problems email pgr_consulting @ yahoo.com

You rated this post out of 5. Change rating

2007-11-09 (first published: )

1,173 reads

Technical Article

Collation Checker

this a quick sproc I put together to do various collation checks. databases that have different collations from serverdatabases that have different collations of columns withindatabases that have column collations different from database collation

4.71 (7)

You rated this post out of 5. Change rating

2007-11-06 (first published: )

2,221 reads

Technical Article

proc to order xp_enumerrorlog

this is a quick stored procedure I put together when trying to find a log for a particular day (xp_enumerrorlogs returns the archive is as a varchar, so 1 is followed by 11, 12 etc rather than 2) sp_display_errorlogs with no parms returns output in archive id order. if the parm 'size' is passed in, […]

You rated this post out of 5. Change rating

2007-09-21

719 reads

Blogs

What to Know about Power BI Theme Colors

By

Power BI reports have a theme that specifies the default colors, fonts, and visual...

A Global Team Meeting

By

The last few years at Redgate we’ve had the entire (or most) of the...

A New Word: sayfish

By

sayfish – n. a sincere emotion that seems to wither into mush as soon...

Read the latest Blogs

Forums

MSOLEDBSQL/MSOLEDBSQL19 - Linked Servers and encryption

By Fozzie

Yes I know Linked Servers can be evil... but they can be fine and...

dbcc clonedatabase issue

By blom0344

I have used the 'dbcc clonedatabase'   schema-only backup procedure many times in the past...

Visit the forum

Question of the Day

The Secondary Database Name in an AG

I am setting up a SQL Server 2022 Availability Group and I am ready to restore the database on the secondary. The primary database is named Finance. However, we also use this instance for QA and already have a database named Finance. How do I configure the AG to use a different database as the secondary?

See possible answers