Viewing 15 posts - 106 through 120 (of 218 total)
Drammy (4/29/2010)
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...
April 29, 2010 at 9:07 am
Brandie Tarvin (4/29/2010)
I don't think the Copy-Only Backups get stored in the tables, though. Do they?
Yes, all backup operations are in msdb..backupset and msdb..backupfile
Just to be sure before I posted...
April 29, 2010 at 9:00 am
Dugi (4/29/2010)
GregoryF (4/29/2010)
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
No SQL Server supports over 512 TB, take...
April 29, 2010 at 7:58 am
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...
April 29, 2010 at 7:45 am
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
April 29, 2010 at 7:26 am
river1 (4/29/2010)
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...
April 29, 2010 at 7:20 am
river1 (4/29/2010)
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...
April 29, 2010 at 7:05 am
river1 (4/29/2010)
Point 1:"msdb..backupset (msdb..backupfile also has lot's of backup info)"
Didn't understood... what's the correct table to query and see the backups?
Thnak you
Both tables contain information on backups taken, take a...
April 29, 2010 at 7:03 am
river1 (4/29/2010)
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...
April 29, 2010 at 6:48 am
alen teplitsky (4/29/2010)
April 29, 2010 at 6:45 am
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...
April 28, 2010 at 12:39 pm
I have 200, 2005, and 2008. I no longer use the 2005 SSMS. No problems
April 28, 2010 at 12:13 pm
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%...
April 28, 2010 at 12:09 pm
The SID's are the same for NT Users, use this SP for SQL users: sp_change_users_login
April 28, 2010 at 10:34 am
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...
April 28, 2010 at 9:13 am
Viewing 15 posts - 106 through 120 (of 218 total)