Viewing 6 posts - 1 through 6 (of 6 total)
Ok, then what is the issue, get the data in SQL then you can start maintain it.
By the way, how big is the data?
November 24, 2011 at 10:39 am
Ok, I think one Oracle DBA can answer about this more how the Statistics will add advantage.
You can google and you may get lot of links for that. Even I...
November 24, 2011 at 9:42 am
Any specific reason you want statistics included in backup? If so, please update statistics and take backup, otherwise, you can do either option.
While taking backup, nothing is updated, Backup operation...
November 24, 2011 at 12:44 am
You might have received Object name as well. Can you share that, it would be helpful to check the object and its use.
-Johnson
November 23, 2011 at 9:59 pm
Yes as said, if anyone add any objects in model which needs to be there when DBA create a new DB.
In SQL 2008 onwards, the recovery model is full, which...
November 23, 2011 at 12:14 am
Other option is,
you can use the Option 'Auto Shrink' in the "Database->Properties->Options"
But this will affect the performance.
Second option is, use
dbcc shrinkdatabase (databasename,truncateonly)
this will shrink only logs, and return back the...
July 13, 2005 at 12:52 am
Viewing 6 posts - 1 through 6 (of 6 total)