Hi..here i would like to know the Backup and Restore models?
Answers were Sorted based on User's Feedback
Answer / naren
Back up we have full and defferential
(incremental),transaction log backups
Recovery models full,bulk, simple
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / laxman
that may recovery models:
simple
bulk-loged
full
| Is This Answer Correct ? | 0 Yes | 0 No |
How to trouble shoot if unable to connect SQL Server
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
how we can store the value like that 001,003,023 etc in sql server 2005
Explain trigger classes i.e. Instead of and after trigger?
What do you mean by sql server 2005 express management tools?
How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?
What are ddl triggers and types of ddl trigger?
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
How to use wildcard characters in like operations in ms sql server?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is the difference between a function and a stored procedure?
What do you mean by recursive stored procedure?
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)