how to get the automatic backup of the database in the sql
server
Answer Posted / guest
Through maintanence plan
| Is This Answer Correct ? | 44 Yes | 9 No |
Post New Answer View All Answers
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Explain what is the purpose of sql profiler in sql server?
Explain what is public role in sql server?
can you implement data mining in SSRS?
What is NOT NULL Constraint in sql server 2012?
Explain the dbcc pintable command when would you use it?
How do I find sql server instance name?
Explain what are page splits? : SQL Server Architecture
What is an index. What are the types?
How many databases instances are there in sql server 2000?
When do you think a developer should use sql server-based cursors?
How to delete a login name in ms sql server?
What is difference between temp table and cte?
What is the downside of using udf?
What is an index in a database?