What is an etl file?
No Answer is Posted For this Question
Be the First to Post Answer
Explain linked server in sql?
What is the purpose of data source?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
What is Schema in Database?
What are number line correlation administrators will use while working with a subquery?
Do you know sql server 2008 introduces automatic auditing?
What are the built in functions in sql server?
How to invoke a trigger on demand?
How to sort the query output with order by clauses in ms sql server?
Explain indexes disadvantages?
what are cursors? : Sql server database administration
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
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)