can you any body tell me the how to decrease the logfile
Answers were Sorted based on User's Feedback
Answer / vani
The log files must be backed up, so that the inactive log
records are truncated after every checkpoint thus freeing
up the logspace to be reused.
Schrink your database (Database-All task-Schrink database)
leave 10% free and the size of the log will schrink
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / prasadhari_m@yahoo.com
take a backup using this command
backup log dbname with no_log
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Answer / rahul
dbcc shrinkfile ( 'databasename', 'size to be shrinked upto
(in mb)')
| Is This Answer Correct ? | 0 Yes | 0 No |
How and why use sql server?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Does order by actually change the order of the data in the tables or does it just change the output?
What are sub-queries? Give example? In which case sub-queries are not feasible?
Explain what is the difference between a local and a global temporary table?
What is truncate table?
Explain comment on transactions?
What is dirty read?
explain databases and sql server databases architecture? : Sql server database administration
What happens if time-only values are provided as date and time literals?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Is t sql the same as sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)