yes, it's no use now.

For future reference, if you have a broken LS plan and the query produces results with identical LSN bases this means that no full backup on...

No good if the table is huge and your storage subsystem is slow. Introduces fragmentation too.

Move the files in a planned downtime...

please post the results of this query

select db_name(database_id), differential_base_lsn

from sys.master_files

where database_id IN (db_id('PrimaryDB'), db_id('SecondaryDB'))

and type_desc = 'ROWS'

group by db_name(database_id), differential_base_lsn

Apply the patches to all nodes that are...

its sounds very much like the database user already exists and is orphaned.

Please post the results of the following

USE [yourdb]

select sid AS LoginSID from master.sys.server_principals

where name = 'theuser'

select sid AS...

Jeff Moden (4/1/2016)

---

I'm thinking that the 1200 files could be due to the partitioning of 1 or more large tables. It's not unheard of for folks to partition by...

is this a virtual machine?

RDMs are raw device mappings, these are LUNs presented to...

This would sound the most likely, check to ensure...

steve.roberts 86619 (4/6/2016)

---

Hi,

Basically got a server and one of the drives is running out of space.

I can add in new log/db files on another drive ( which has lots of...

In that case if you want to add an Ssrs instance with the same instance name as an existing sql server...

The machine performing the scan with sqlcmd or sqlping must have network connectivity to all network segments to discover all SQL servers

indianscorpion29 (4/4/2016)

---

Hi All,

We have a production instance which has the SQL database engine installed. (Sql server 2012 with SP2 enterprise edition).

I have a requirement to install SSRS on this instance...

You've got a spill to tempdb thats not playing nicely in the park.

Do you know who the user is running the query and the actual query they're running.

If not you'll...

would have been helpful to get some info from sys.dm_tran_locks

vincenzo_capelli (4/6/2016)

---

Hi,

I have to plan Storage Area Network maitenance into the D.Recovery site.

With this activity the Sql server configured as secondary replica should be stopped.

What's the best practice for...