I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardMS SQL Topic   Print This     

Transaction Logs

Transaction Logs in MS SQL topic (part of our DBA, Databases, & Data group).

Quick Search: Transaction   Transaction Logs  
Leslie
 (Inactive)
Modesto, CA
Help!!!!!

I am at a new job and have just been asked to move the transaction logs on our SQL server. This may be a stupid question, however how do I do this. Please help me a.s.a.p.

Thanks in advance. Confused
 Posted 20 years ago (Thread Starter)
Comment Quote
About Leslie -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2400, 2 replies
Thread Started 6/6/2001 12:19:00 PM
View Counter=2517
Location=Modesto, CA  
Joined=20 years ago   MB Posts=7  
Most Recent Post
Leslie
 (Inactive)
Modesto, CA
This is only going to back the log files up (am I correct)? Confused I need to acctually move the files. I am trying to improve performance by seperating the log files from the databases. Thanks in advance! Big Grin!
 Posted 20 years ago (Thread Starter)
Comment Quote
About Leslie -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2407 (Level 1.1)  Reply to 2400
Thread Started 6/6/2001 4:26:00 PM
View Counter=2
Location=Modesto, CA  
Joined=20 years ago   MB Posts=7  
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
Okay, I'll assume you know how to find the SQL Server tools on the server, so here's one way to do this:

You can do this from the SQL Server Enterprise Manager (which is where I found the WinHelp file that explained this) or from a Query console logged in as the system administrator.

For this example, I'll assume your database is named "Yosemite" in SQL Server. I'll also assume that the logs are being kept on the server drive, but you've been asked to move them to a folder called "SQLLogs" on the mapped network drive "M" (another machine in the domain, mapped to the letter "M" on the WinNT server).

In a query window, type the following SQL:

BACKUP LOG Yosemite
TO DISK "M:\SQLLogs\Yosemite_DB.log"

That should help for starters... Big Grin!
 Posted 20 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2406 (Level 1.2)  Reply to 2400
Reply Posted 6/6/2001 3:28:00 PM
Location=Las Vegas, NV USA 
Joined=19 years ago   MB Posts=442   KB Posts=19  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P123A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #2400 Counter
2517
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech