Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: danlout144
- Order by date
-
restore database
It would be good to know an error what you did receive. But, before you can recover a database to its latest point in time, you must back up the tail of its transaction log. The tail-log backup will be the last backup of interest in the recovery plan for the database. Because no transactions can...- danlout144
- Post #2
- Forum: Microsoft SQL Server: Programming
-
backup a table
I would suggest two way to you. Which you will choose depend on the reason why you want to backup a table. If you need just the data and you want it locally (on the same database/server) then you can use the first option, through T-SQL scripts. If you need to back up the table to prevent data...- danlout144
- Post #2
- Forum: Microsoft SQL Server: Programming
-
backup query result
I would suggest next. If you have access to Management Studio, you can save query results to a file quite easily: 1.Open a query window. One way to do this is by right-clicking on the database name in the Object Explorer. 2.You might want to write the query and run it there first, to...- danlout144
- Post #5
- Forum: Microsoft SQL Server: Programming
-
backup query result
Could you please explain in a bit more detail what it is you need?- danlout144
- Post #2
- Forum: Microsoft SQL Server: Programming
