Hi,

I'm in the same situation as you, I think I'm going to use this book to study:

http://www.amazon.com/SQL-Server-2008-Administration-Certification/dp/0470554207/ref=sr_1_1?ie=UTF8&s=books&qid=1278508895&sr=8-1

Regards,

Jose S. Oyervides.

Hi Nikki,

You have to have permissions (any) in order to see anything else, this is new from SQL 2005.

You can try with:

USE <your_db>

GO

GRANT VIEW DEFINITION TO <user>

Which will grant the...

Hi,

I'm not sure is related to the issue you are seeing, but I think you should run cluster and SQL services with different accounts, this way you can change their...

Hi,

What are the security properties of the linked server? What message is he viewing when he is triying to access?

Regards,

Jose Santiago Oyervides.

Hi,

Ideally, you should rebuild the indexes only when their fragmentation is above 30%, if you are rebuilding all indexes, then you only need to update the column statistics:

http://sqlblog.com/blogs/ben_nevarez/archive/2009/10/06/rebuilding-indexes-vs-updating-statistics.aspx

Regards,

Jose...

Hi,

You can check the status with:

select * from sys.databases

also, you can check in the ERRORLOG (SQL) or Event Viewer if something happened with those databases.

Regards.

Jose S. Oyervides.

You need to setup delegation in order to the server be able to pass the user's credentials to the another SQL Server.

SPN stands for "Service Principal Name".

Check this article:

It's possible.

Just select in the General tab: backup log: transaction log and in Options tab select "Back up the tail of the log, and leave the database in the restoring...

Hi,

Some time ago I made a script in Powershell to script all linked servers:

http://practicascomunes.blogspot.com/2008/08/utilizando-poweshell-con-sql-2005-smo.html

It's written in spanish, but I think you can translate it with google.

Hope it...

Hi,

What does return this?

select @@version

Hi,

How are you going to handle the drop-create users in the backup server? Do you have your scripts ready for this?

I would suggest also disabling all jobs in primary server...

Hi,

You need the linked servers between them to make it work, otherwise, how are you going to establish the connection?

Regards,

Jose Santiago Oyervides.

Ok, You can try different options to make it work.

You can try this:

1. Extract the msi file from the SP3 installer file (you can use 7-zip) and run it from...

Hi,

Can you check you have this file: C:\WINDOWS\Installer\18cecb4.msi

Keep in mind that the folder c:\windows\installer is hidden, you have to explicitely type it.

Regards

JSO.

Hi,

There could several actions to make it work.

First, make sure you are running the installer locally, when checking for the logs look for the string "return value 3", most of...