The left over transaction log backups are useless for a restore, they require the earlier log backups to function correctly.

That means the only recovery point is 8pm at the time...

http://support.microsoft.com/kb/934749

Have a look at that, you can use the /PASSIVE switch on SP2 CU6 or higher.

Something like this, but run it for each database:

declare

@pagesbigint-- Working variable for size calc.

,@reservedpages bigint

,@usedpages bigint

,@rowCount bigint

select

object_name (p.OBJECT_ID) as ObjectName,

index_id,

sum(a.total_pages) as ReservedPages,

sum(a.used_pages) as usedpages ,

...

I'm also finding it randomly slow. I've mostly stopped checking the forum due to how slow it is.

Right now it took about 30 seconds to open this...

To add to Eirikur Eiriksson's comment, if it's not SIMPLE recovery it won't overwrite.

Eg. Add this after the create database statement:

ALTER DATABASE [_tmpdb] SET RECOVERY FULL

GO

It will not overwrite....

-- Update usage

EXEC sp_spaceused 'dbo.pr_history', @updateusage = N'TRUE'

-- Check for ghost records

select * from sys.dm_db_index_physical_stats(DB_ID(),OBJECT_ID('pr_history'),NULL, NULL, 'DETAILED')

-- Rebuild the index

ALTER INDEX [pr_history_PK] ON [dbo].[pr_history] REBUILD

SQL 2000: Error 'Row_Number' is not a recognized function name.

SQL 2005 to 2012: 10 distinct rows returned, answer should be C.

When you RDP to one of the cluster hosts and run Failover Cluster Manager, then click SQL Server (InstanceName), the virtual SQL Server name should be displayed under "Name:" along...

Check with your networking guys, if you tell them you cant telnet to port x from this IP to this IP but can elsewhere then they should be able to...

The instances will not be running on the default port 1433. Check which port they're running on in configuration manager, then try connect remotely using the ip address and...

Have you tried connecting to the DAC or running SMSS locally on the desktop and using localhost,port ?

Check which port each instance is running on in SQL Configuration Manager - SQL Server Network Configuration - TCP/IP - IP Addresses - IPAll - TCP Dynamic Ports

Connect using the...

dwhitley (9/4/2014)

---

I guess I'm one of the few just getting the msg 8134 when I run this? Running on 2008.

Msg 8134, Level 16, State 1, Line 1

Divide by zero...

Navigate to your default trace path on the server and look for older default trace files.

For example if the following query returns, "D:\MSSQL11.MSSQLSERVER\MSSQL\Log\log_31.trc", then goto the folder and check for...

No, it will not clear out the log or mark the transactions inactive.

Just to be sure (as you have found answers suggesting otherwise), I test this with the "Sync With...