We have a production database (SQL Server 2005 SP1) of 15GB size. I was wondering what is the best? To use RAID Stripping or Filegroup Stripping?Or...
My production database server (SQL Server 2005) hosts the main database (about 15GB).There are thousand of insert-update statements in this db during...
every night i execute a rebuild index task. Do you believe that this task affects all the pages? Is this the reason that the differential is so...
joechang and satya, first of all thank you very much for your help. I run again the differential backup and I realized that the reason for the delay...
I must keep the db to SIMPLE recovery model and I dont need to have t-log backups.The insert statements come from my customers applications so I...
I am using SQL Server 2005 SP1 and I have a production database (12GB). My database has a huge table taking about 65% of its size. A lot of insert-...
initially the growth is in MB for both, Data and Log file. After the execution of the maintenance plan (Shrink DB) the file growth seems to remain...
Using sp_helpfile to my database (SQL Server 2005,SP1) I get the following results Data File size=5103616 KB, maxsize=Unlimited, growth=204800 KB...
satya, the copy and backup jobs terminate succesfully but the restore job always returns the following message Error: Could not apply log backup...
Yes, but my secondary database is in restore or standby mode during the log shipping (I cant see its content, its data etc) and the Backup operation...
Thank you very much. Concerning your first answer, I face this problem: The backup to the primary and the copy process from the secondary have no...
Thank you very much for your answer but the purpose of having DatabaseB is to change its schema, to insert data during the development phase (for...
I have an SQL Server 2005 (ServerA) hosting the application DB(DatabaseA) accessed by many customers who insert, update, delete , select data. I need...
Separate names with a comma.
