1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
- 3 Answers
- 6874 Views
- CarrizalSoft Technologies, IBM, I also Faced
- E-Mail Answers
Answer Posted / basha
SELECT * FROM SYSFILES, run this query against the db to
which u have to find file size.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
How to manipulate data from one table to another table ?
How to insert a new row into a table with "insert into" statements in ms sql server?
What are the grouping functions?
What are the restrictions that views have to follow?
Explain mixed authentication mode of sql server?
What are the different type of replication in sql server?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
Write a SQL query to delete a table?
Where sql server usernames and passwords are stored in a sql server?
What is the default fill factor value?
Can you pass expressions to stored procedure parameters?
What is the difference between Clustered and Non-Clustered Index?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Do you know the capabilities of cursors?
How to verify a user name with sqlcmd tool?
