remove traces of any redundant secondary databases on the secondary server using

USE master;

go

exec sp_delete_log_shipping_secondary_database

@secondary_database = 'secondary_database';

Once you're sure any LS scenarios have been cleared remove the alert job...

vamsi056 (10/15/2012)

---

Hello friends,

Iam a newbie to sql server dba tasks,

I want to install sql server 2008 r2 enterprise edition on my laptop where os is windows server 2008 r2...

The log shipping meta data keeps a trcak of files copied and restored. Start messing with the plan itself and it will likely fail. If you want to run LS...

greg.huxley (10/15/2012)

---

Perry, Steve

Thank you for the information. Glad I checked before attempting! Are there any dependencies on the order in which I do the migrations i.e. do I...

chewychewy (10/12/2012)

---

Hi,

By default installation, SQLServer2005MSSQLuser$<INSTANCENAME>$MSSQLSERVER is having the below access to SQL Server Data folder.

Full Control

Modify

Read and Execute

List Folder Contents

Read

Write

Auditor highlight that this is a security concern and want...

As i said, you'll need to be patient and run it for longer than 20 mins 😉

tut tut, really. A simple google search reveals this link

Just in case you can't find it :Whistling: here's the Windows 2012 Eval too.

OK, so when it states same edition and version it seems like it only refers to the major build version not the minor build version

why don't you re run...

sej2008 (10/13/2012)

---

Thanks for your reply but half the problem is solved

I am log shipping from pc1 to pc2 as

an pc1\administrator and having same password on the machine still...

Technically, with contained databases in 2012, you are bypassing connections through the server as you are authenticated directly by the user database.

Under Oracle an instance is a database, its an...

greg.huxley (10/12/2012)

---

Hello,

I have two physical servers, one running SQL Server 2005 and one SQL Server 2012. I have been tasked with migrating the 2005 databases to 2012 using the...

Run this per...

ericwenger1 (10/12/2012)

---

I can't seem to be able to convince the development manager, who I report to(which is abnormal in most settings) that shrinking the database will not improve performance. I've...

oh for sure, I don't doubt that. But, all the same, these things can and do happen