Answer Posted / monal
in SQL Server 2005:
ALTER DATABASE <Database Name> MODIFY FILE
(NAME =<File Name>, MAXSIZE = <Size>)
| Is This Answer Correct ? | 9 Yes | 8 No |
Post New Answer View All Answers
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How do you trace the traffic hitting a sql server? : sql server DBA
what is the role of dip user in our database?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what is the diffrence between core dba and apps dba?
What are the operating modes in which database mirroring runs? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What would you do with an "in-doubt" distributed transaction?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA