Viewing 15 posts - 16 through 30 (of 2,462 total)
What you did was actually improper way to manage log if its is Production server. because it can break the log chain.
This link can help you better http://www.sqlservercentral.com/stairway/73776/
March 10, 2014 at 7:04 am
Another ONe cent.
Has the restore done on server having same hardware configuration(if done on different server ) ?
December 6, 2013 at 3:55 am
This link will help you http://www.mssqltips.com/sqlservertip/2553/different-ways-to-monitor-log-shipping-for-sql-server-databases/
November 25, 2013 at 3:08 am
adonetok (11/21/2013)
I did backup.The problem is that order.bak file is not under list.
are you looking at correct path/folder? OR do you have any (suggested) BACKUP file extension like .BAK...
November 21, 2013 at 7:19 am
Krishna1 (11/18/2013)
why the initial size keeps changing?
Either MODEL db initial size or somebody (externally)intentionally doing this.
November 19, 2013 at 3:48 am
Krishna1 (11/13/2013)
Noticed that the initial size of the transaction log is Approximatly 7GB. Is this the reason why the trnasction backup file size is 7GB?
Setting appropriate initial...
November 14, 2013 at 6:34 am
darwesh1992 (11/4/2013)
Which things would you personally improve about this schema? Where do you see potential problems
Ahh..it seems like its interview question's pool.:-D
November 14, 2013 at 6:18 am
Any Drive(disk) level changes happened ? like comparatively low graded disk is being used now.
November 14, 2013 at 5:15 am
mpradeep23 (11/13/2013)
how do i join tables with out joins
You can .... for that you have to do table level changes like merging two tables (which contains parent-child relationship...
November 14, 2013 at 5:11 am
DBA means a person who is having good knowledge and experience which defintely means that those people dont fall in the category of freshers/newbies ..even if we talk about accidental...
November 13, 2013 at 7:20 am
K Currie (11/12/2013)
Should I reindex before/after? Update Stats? etc?
Here is the link http://www.mssqltips.com/sql-server-tip-category/38/indexing/
November 13, 2013 at 7:08 am
gbr405 (11/13/2013)
Hi All,Kindly suggest me for ,Best Institute in Hyderabad for SQL Server DBA.
Adv thanks
Bharath
i dont think there will be any institute who can give you good level...
November 13, 2013 at 7:06 am
Why the database needs to be set "trust worthy" in case of SB ?
November 12, 2013 at 3:55 am
Viewing 15 posts - 16 through 30 (of 2,462 total)