Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the how to decrease the logfile
- 4 Answers
- 6143 Views
- I also Faced
- E-Mail Answers
Answer Posted / lekhrajdeshmukh
We have to decrease the size of a log file by shrinking the
large file.
Syntex:-
DBCC dbname
go
DBCC shrinkfile(filename,sizevalue)
go.
for eg I want to shrink the filename data of databse userdb
to 7 mb.
dbcc userdb
dbcc shrinkfile(data,7)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain data warehousing in sql server?
What are the main sources of data?
How do you size a resultset?
Explain the difference between control flow and data flow?
What is delete query?
What is join and name different type of joins?
What is store procedure? How do they work?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is replication with database mirroring? : sql server database administration
What is the importance of concurrency control?
How do I install sql server?
What the difference between UNION and UNIONALL?
What are the advantages dts has over bcp?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to choose all records from the table?
