kkanaya (10/16/2012)

---

A user requires out of hours backup and restore of a SQL 2008 R2 database on a regular basis. I could schedule a script to run but don't know...

Number of indexes?

open a cmd prompt on the machine and post the output of

NET START

just out of interest which article were you reading?

I actually didn't want to...

Litespeed is a packaged installer which installs the binaries.

You then need to launch the Litespeed configuration wizard, you could check with Quest if there is a way to script this...

configure what exactly?

Whats voodoo about creating a table, inserting some records and truncating...

that is correct, did you perform the create, insert, truncate that Gail advised

can you supply a little more info on the virtual environment, are the VMs clustered directly or are you referring to host clusters?

i think the user was primarily confusing NOTRUNCATE and TRUNCATEONLY on DBCC SHRINKFILE with the BACKUP LOG scenario, i could of course be wrong but i'm sure this is the...

😉

Your article mentions

distas

---

Here is important point in regards to DBCC SHRINKFILE not to be misinterpreted: DBCC SHRINKFILE (<Transaction_LogFile_LogicalName>, TRUNCATEONLY) does truncate a transaction log file, i.e. breaks the LSN -...

vamsi056 (10/16/2012)

---

i only installed Active Directory users and computers role ( to work with assigning user roles and permission from sql server to windows authentications), and i didnot installed DNS...

set the backup drive as a dependency on the sql server service resource and change the drives\paths on the sql server instance properties page

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...