Drammy (4/29/2010)

---

Hi all,

I have a reporting database that pulls large amounts of data from a production databases and restructures it to present the data "logically" as it is presented to...

Yes, all backup operations are in msdb..backupset and msdb..backupfile

Just to be sure before I posted...

Dugi (4/29/2010)

---

No SQL Server supports over 512 TB, take a look more closely,...

Aside from the fact that the largest size of a DB os 500TB, assuming you even had something that large.

How Many:

Teamed Network Cards?

HBA Controllers?

Drives...

Are you really sure it's 800TB and not 800GB?

SQL 2008 only support 512TB Databases

http://msdn.microsoft.com/en-us/library/ms143432.aspx

So does SQL 2005

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

river1 (4/29/2010)

---

Point 1:

It seems that this table backupset only contains information of the backups that where made to backup devices. At the company we make backups to file. when i...

river1 (4/29/2010)

---

point 4:

So , if i have a database named test1 and make three backups and then restore one of the backups, those three backups will still be in that...

Both tables contain information on backups taken, take a...

river1 (4/29/2010)

---

Hi,

I need to know some information about backups.

1) in SQL Server 2005 where is the table that as the information about all the backups that where made...

alen teplitsky (4/29/2010)

---

i ran a test on a non-critical SQL server where i set the parallelism to 1 instead of the default 0. all the jobs ran slower and it...

two companies ago (where we had a very thorough inventory), we had

675 instances on 195 servers (this included dev/qa/prod/dr)

last company, had over 2600 instances scattered on over 1,000 servers

Both are...

I have 200, 2005, and 2008. I no longer use the 2005 SSMS. No problems

This reminds me of a sign I saw in the Frankfurt Airport a few years ago "97% of the Fortune 500 use Oracle"

I'd bet that somewhere, in some department, 99%...

The SID's are the same for NT Users, use this SP for SQL users: sp_change_users_login

http://msdn.microsoft.com/en-us/library/ms174378.aspx

Are the jobs set to for "On Failure Action" to "Quit the Job Reporting Failure"?

Sometimes jobs are set to report success even when they failed (there are good business reasons...