Really need to get an idea of the current file sizes, post the results of this please run against your database

USE YourDB

GO

selectname

, size / 128 AS FileSize

, case max_size

when -1...

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