river (6/30/2009)

---

Ok, i understud.

What about if i didn't had any SPs installed yet on my SQL Server 2005 developer edition with vista OS? by default the builtin\administrators have sysadmin permissions...

If...

If...

Review the article I link to in my signature to get a better understanding on how to manage your transaction logs.

The problem is clear - you can only upgrade to SQL Server 2008 Express, unless you installed Advance, which is then upgradable to Workgroup.

What you can do is upgrade to...

There is nothing special about configuring log shipping in a clustered environment compared to a standalone instance. They are setup/configured the same way.

Here is your starting point: http://msdn.microsoft.com/en-us/library/ms188698(SQL.90).aspx

Your problems...

The generally accepted naming standard is to name secondary data files...

As George has stated, there are no reason to have that option enabled. Turn it off - and also (as George stated) turn off auto shrink if it is...

JC (6/29/2009)

---

Hi Jerry

I am looking at your code for tempdb files

I am new to sqlserver 2005

Not up to speed on TEMPDB files yet

i understand the creation of the multiple tempdb#.mdf...

What that message tells me is that you have the database set to auto close. That means the database is closed when nobody is accessing it anymore and then...

Krasavita (6/29/2009)

---

1.How to monitor the free space on the database files?

2.How to check Instant File Initialization?

3.This for Logs:

EnableAutoGrowth set to true

FileGrowth set to true by 10%

RestrictedFileGrowth set to 2,097,152 MB

4.This...

Are you looking at running update scripts? Or, is this only going to be selects? If only selects, and you are running Enterprise Edition you can create a...

If the database is set to full recovery model, you MUST run frequent transaction log backups. How frequent they are run will be determined by your business requirements. ...

The DATEDIFF function in Reporting Services is not the same function we have in SQL Server. It is the equivelant VB.NET function. Although it does work the same,...

If you are not running Vista or Windows Server 2008 - the provisioning option at the end of SP2/SP3 can be safely ignored.

On either of the above OS's - if...