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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to create a backup server
Hi, You can create up to 16 named instances on SQL 2000 server, but only one default instance. I would recommend, if possible, run a new install and create two named instances. This way, you can set up log shipping on the production instance and simply copy any changes to the secondary, backup...- thomadma
- Post #4
- Forum: Microsoft SQL Server: Programming
-
need to truncate log file?
BACKUP LOG DbName WITH TRUNCATE_ONLY GO USE DbName DBCC SHRINKFILE(DbName_log, size want to shrink it to). There are numerous examples on BOL in case you are still confused. This should help you out. If you want you may set it up as a job on whichever database the log file seems to grow...- thomadma
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Database Diagrams
Hi, I am under the impression that database diagrams can only be created by members of the dbo role or the sa group. Is that correct? Maria- thomadma
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Setup and Administration
