balbirsinghsodhi (5/27/2009)

---

I was told by my boss that I have to do powerpoint demostration about DBA work to the users in our company.

Actually, we are doing some kind of...

SSRS db's behave just like regular db's you cannot backup just one report you have to backup the whole database.

Backup and Restore Operations for a Reporting Services Installation

http://msdn.microsoft.com/en-us/library/ms155814(SQL.90).aspx

Moving a Report...

http://msdn.microsoft.com/en-us/library/ms187974(SQL.90).aspx

shannonjk (5/8/2009)

---

Alex, I really like that idea.

The only problem is, I have no idea how to create an ODBC connection or how to set up those privileges to it...

Open VBA in Excel draw a command button and in the sub routine insert this code:

Sub ExecuteSQLJOB()

Dim Chan As Variant

'Open a channel to a SQL Server data source

Chan = SQLOpen("DSN=SQLServer")...

When you run sql 2005 setup it will ask you if you would like to install as default instance.

Choose default instance and the next option will ask you if that's...

Your default instance is 2000 and a 2005 is a named instance.

If you open SQL Server service manager you can see both instances or you can browse to Program Files.

C:\Program...

since it's a possible index corruption you should rebuild your indexes and schedule it at least once a week via maintenance plan.

Interesting...

do you see anything when you run dbcc opentran?

Run the same script but give it a different database name and remove replace.

if you still get the error you should restart...

Run this:

RESTORE DATABASE [trackit65] FROM DISK = N'C:\test\trackit65_it_cw.bak'

WITH FILE = 1, MOVE N'TRACKIT65_IT' TO

N'C:\SQLData\TRACKIT65_IT.mdf', MOVE N'TRACKIT65_IT_log' TO N'C:\SQLData\TRACKIT65_IT_log.LDF', NOUNLOAD, REPLACE, RECOVERY, STATS = 10

Last statements says that restore completed.

Run dbcc checkdb to make sure.

Are you running windows 2003 server? or Vista?

You should login as admin and reinstall SP2.

homebrew01 (3/15/2009)

---

I thought I had run sp_help_revlogin_2000_to_2005 , but still didn't see the databases assigned to the sql account. I dropped the SQL login and re-ran sp_help_revlogin_2000_to_2005 and I...

Gift Peddie & Ellis

Our SSIS packages interact with a 3rd party ETL tool called DataLever which cleans and then loads all the data from 16 different sources into a Staging...

DBCC CHECKDB