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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mgale1
-
Unable to start MSSQLSERVER service on SQL 2005
Thanks mutley1, I switched off the VIA protocol and the service started first time of asking. You're a STAR!!!!- mgale1
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
Advice re. backing up tranaction logs
I agree - defintely use a maintenance plan - it takes away a lot of the pain. You can use the Maintenance Plan wizard to schedule both datafile and logfile backups as well as integrity checks. SIMPLE recovery mode means that the transaction log is uneeded and you dont need to back it up...ever...- mgale1
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
Maintenance Plan versus Scheduled Backup Job
Mike, You should definetely be able to do what you want via the Maintenance Plan Wizard. As far as I am aware the backups generated by maintenance plans are 100% complete; that is, they do contain user defined stored procedures and all other database objects. Any backup, whether maintenance...- mgale1
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
Unable to start MSSQLSERVER service on SQL 2005
Dear Tek-tips, I am trying to run SQL Server 2005 Evaluation Edition on Windows Server 2003 Entreprise Edition SP1. Until yesterday everything was running fine but today I am unable to start the MSSQLSERVER service. The Analysis Services Service and the Integration Services Service starts up...- mgale1
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Setup and Administration
