Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hunkydude81
Starting Member
4 Posts |
 Posted - 2008-01-25 : 02:19:41
|
| Hi all,I am pretty new MS SQL server,I am actaully working as an SAP BASIS ADMIN and 1 of our client is on MS SQL 2005 with SP1 as the DB and Win 2003 as the server.I just wanted to know 1) How can we login to the dbase from the command prompt?2) How to alter the database to NON-ARCHIVE mode and back to ARCHIVE MODE ?I just wanted to execute few SAP activities for which i dont want the database to generate the archive logs, so i need some assistance.Hoping to START GOOD here in this forum...Thanks a million in advance to all Waiting to hear from all the SQL gurus.RegardsHunky |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-01-25 : 20:34:18
|
| You can use osql commands to log on to the SQL Server via the command prompt.I am not sure I know what you mean by Archive Mode. What makes you think that the database is in this mode? I have worked a little with SAP and I am wondering if this is something that SAP is showing you or something that SAP has set the database to, and it is in single mode.When you open the server in SQL Server Management Studio, what does it show as the database status?Chris Shawwww.SQLonCall.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-25 : 23:05:00
|
| 1. Use sqlcmd for sql2k5.2. Do you mean recovery model? You can't disable logging, what you can do is switching to bulk-logged model to reduce log. |
|
|
|
hunkydude81
Starting Member
4 Posts |
Posted - 2008-01-27 : 02:14:16
|
| Hi all,Thanks for all your valuable inputs...I am now into a confusion that if Ms SQL can be switched to and from Archive mode to non archive mode..Usually this happens in Oracle database..For more information about the current status of the DB, i will soon post it here....My ultimate AIM was that during a process of running 1 script at the SAP level it will generate many log files which are not important for me...so i want to disable that feature for the time that the script runs and get it back to NORMAL after it completes...Waiting to hear from you...Thanks a million in advanceRegardsHunkydude |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-27 : 14:38:31
|
| Transaction can generate logs but not log files in the db. If script creates log files, it's nothing to do with sql. You need modify script to fix that. If you want to disable db transaction logging, it's impossible in sql server. What you can do is switching to bulk-logged recovery model as I said. By the way, sql server works in different way from Oracle. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-01-28 : 01:37:08
|
| there is no archive log mode in sql server.VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
|
|
Turning DB to NON-ARCHIVE mode