There are only two reasons why one should stop and restart a sqlserver instance:

- to apply a servicepack/hotfix

- to have tempdb to its original or set starting size ( in...

- commit and overwrite .. yes , SHRINK ... No !

- things that can cause your log files to grow with simple recovery :

-- long running transactions

-- huge...

Gail posted a very explanatory article on this subject !

http://www.sqlservercentral.com/articles/64582/

start with the Upgrade advisor for sql2005 !

It will point you to potential issues with your db.

- if a filegroup gets filled up and cannot auto extend any files , you'll get an errormessages stating "filegroup full".

So you nolonger can add data to it, rebuild indexes,...

- also, with these ndf files, it is best to know if they are all allocated to a single filegroup or not. Having multiple files allocated to a filegroup would...

As always, it depends 😉

- For small files, rarely requested, you could use a dbmail solution and mail the query result as attachement.

- another alternative is to use a sqlagent...

2 things:

- there is a faulty path in your script !

Should be SET @FileName = 'd:\aveen.txt'

- has your sqlserver instance service account been granted read access to...

By default, there is no order in a set !

1 things you can do:

- Add an order by clause to your select statement.

Keep in mind order by follows the order...

for sure you can define your dns alias like "OurVeryNiceVirtualSQL" but to get to the actual instance (you may have many on your nodes), you'll also have to provide the...

This will for sure get you on track : http://www.sqlservercentral.com/scripts/31797/

I depends 😉

$$$ caused me to have to build my own inventory solution, providing simple history information for instance settings, databases, tables, indexes and volumes.

And a good lesson it has...

satishthota (9/15/2009)

---

I had created following table

Create Table emp(empid int,ename varchar(30))

Insert Into emp values(101,'A')

Insert Into emp values(102,'B')

Insert Into emp values(103,'C')

and I had created following view on emp table

Create View Vw_EmpDet

as

Select empid,ename...

please read this for your options with sql2008 editions and upgrade options:

http://msdn2.microsoft.com/en-us/library/ms143393.aspx

- You can post the results of the DBCC checkdb if you want to.

- The main reason why you cannot just switch to full recovery, run a logbackup and...