The DB woun't grow beyond 500,000 rows including all the Table's ... Kay
Hi, I have to create a new database . I need around 15 Tables to be created . 2 of the Tables have around 80 columns . Rest of them have 5-10...
Hi, I have an excel sheet with the Specific Backup Details. 1.Server Name (Eg: Prod) 2.Database name ( Eg:ABC) 3.Backup Job (Eg: Prod...
It is the "Distribution" database I was looking for.... I didn't know it comes under system databases .. Is it necessary to backup this database ??...
Hi, I queried select * from sysdatabases and got list of 30 databases. But I have 29 databases in the instance (GUI) . Why doesn't the DB...
Got a better way of verifying this. Get in to the Job history and drop down the Job details and it shows up the Litespeed info if it has been backed...
Thanks for the help.
We have around 80 Back up Jobs . A windows authenticated login with the SA permissions is used for the Backup Jobs . And , I could get the access on...
I don't have access to the backup server . I am checking the T-Sql in the backup Jobs and differentiating by the SP and T-SQL used for backup. And...
Sorry,,, I didn't mentions. Its SQL 2005 . other than the T-SQL ,,,, is there any other option to check this ?? regards kay
Hi , WE have a PROD environment with around 200 DB's. We used native SQL backups for DB backups. Recently, one of the DBA installed Quest...
Hi All, Its not a real time question,,, But a question I faced in interview. Just wanted to if some one could answer it . We have a database...
In our existing environment, We have SQL 2005 and Varicent Tool on same box. We have specific SSIS Packages which were put in a batch files and...
Separate names with a comma.
