Can we perform backup restore operation on tempdb? : sql server database administration
- 1 Answers
- 1085 Views
- I also Faced
- E-Mail Answers
Answer Posted / Snigdha Jauhari
No, you cannot perform a regular backup or restore operation on the tempdb database in SQL Server. Tempdb is automatically managed by SQL Server and does not need to be backed up or restored like user databases.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
do you know how to configure db2 side of the application? : Sql server database administration
What is self contained sub query?
How do I find the sql server version?
Does view occupy space?
How to provide default values to function parameters?
What is the difference between for xml raw and for xml auto?
How do I start sql server 2017?
What are the source of constraints?
Can you index views?
What are wait types?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How do I find query history in sql server?
What are the different subsets of sql?
What is the primary use of the model database?
