what software level are you on ?

select @@version

You are using a login that is member of the sqlserver administrators group, right ?

Judy (2/19/2009)

---

Actually, I applied SP3 at my new active/passive Cluster server and did test. Everything looks fine for SP3. But our SAN was broken somehow and every setting on both...

russell.sage (2/19/2009)

---

On this subject I have a quick question. I can't recall since it's been awhile since I've seen an install of SQL but is it possible to apply...

Check "Monitoring Mirroring Status " in Books online to start with.

It explains there is a whole set of tools to serve you.

Thank you for the confirmaton.

I did set it to checksum on the upgraded databases.

Shouldn't be necessary on SQL 2005 or...

Another save point has been set 😎

I know (and have activate on all our db) PAGE_VERIFY at db level.

Is my perception correct that this would detect any issue as...

We doublechecked all clustered things were hosted on the same node.

(quorum + instances)

- shut down all applications that use sqlserver (because you know the instance(s) will get offline at some...

We use this sequence:

1) restore the db to SQL2005

2) DBCC for DATA_PURITY

3) switch to dblevel 90 (if possible)

4) rebuild all indexes (individually)

5) dbcc updateusage with count_rows

6) sp_updatestats

7) synchronize users

8) create...

rhjohnson (2/17/2009)

---

Thank you, ALZDBA. I have made adjustments to my database as you suggested. The only thing I left null was the ModelID in the tblPDF because I...

Jeff Moden has written a couple of great articles on this topic:

e.g. http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

it is a common design issue to just use nullable columns !

DocDesc nvarchar(50), null

Filename nvarchar(25), null

Filepath nvarchar(100), null

InsertDate datetime, null

UpdateDate datetime, null

FK LangID smallint, null

Avoid the...

As Steve stated, it is the sqlserver service account that needs to be granted write access to the path that you want the backup to be written to.

If you are...

Books online states these restrictions:

Restrictions

Because the DAC exists solely for diagnosing server problems in rare

circumstances, there are some restrictions on the connection:

To guarantee that there are resources available for...

In stead of doing the delete... try out your re-load scenario using:

truncate table yourtable

This is the fastesd way of emptying a table and it will reuse the space.

Regarding the log...

did you address the ldf file using UNC ??

Pointing to a remote disk or fileshare ??