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!
-
Moving SQL Server 2000 TempDB .mdf File
Replying to myself on this one... Microsoft announced a bug (and a fix) to this one... on Fri 2/16/2001... In fact, there is a problem trying to relocate SQL Server 2000's TEMPDB .mdf file onto another drive other than where it was installed...- bbturner
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Can I place my Stored Procedures in VSS
But remember -- (as I just read in a Text Book for SQL Server 7 & 2000).. Stored Procedures themselves do not avail themselves to self-administering versioning - yet.- bbturner
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Can I place my Stored Procedures in VSS
Yes, you may place your Stored Procedures in Visual Source Safe.- bbturner
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Moving Backup files to another drive
As long as the backup file is NOT ACTIVELY in use by SQL Server, yes - you may drag and drop the file to a new directory; and the directory may be on a different drive - on a different array. If you don't change the target backup destination for the 'next' backup -- that's ok. SQL Server will...- bbturner
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Moving SQL Server 2000 TempDB .mdf File
I am trying to mover SQL Server 2000's TEMPDB .mdf file from the installed location (C:\MSSQL\DATA...) to another drive (E:\MSSQL\DATA...) Upon completion, the SQL Server Agent Service will not start - stating "Trying to Recover SQL Server Database' The rights are ok (local admin) and I...- bbturner
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
