Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Access to MSQL performance issues !
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 7

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 11 October 2005 :  10:01:09  Show Profile
Btw, how do I make a backup locally on the MSSQL database using DTS ?

Thanks
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 11 October 2005 :  10:04:45  Show Profile  Visit HuwR's Homepage
quote:
Originally posted by wii

Btw, how do I make a backup locally on the MSSQL database using DTS ?

Thanks


quickest way would be to DTS it to an access db or set up MSDE on your machine and DTS it to that.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 11 October 2005 :  10:07:02  Show Profile  Visit HuwR's Homepage
quote:
Originally posted by wii
That server sure performs well

Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 11 October 2005 :  10:16:37  Show Profile
Thanks.
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 11 October 2005 :  11:33:40  Show Profile  Send pdrg a Yahoo! Message
you can also
>>use SQL Server's builtin backups and just ftp/transfer the files and restore them locally
>>using EM, take the db offline, copy the .mdf file, bring the db back online and copy the .mdf file locally (and attach it to your local SQL Server)

First option is more classically elegant, second will be smaller filesizes (no transaction log to worry about)

You'll probably need elevated privs for both of these options, by the way :)

hth
Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 11 October 2005 :  14:12:42  Show Profile
Download to local Access DB works fine, but it adds 25% filesize to the original.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 11 October 2005 :  14:17:07  Show Profile  Send ruirib a Yahoo! Message
Tried to compact the database?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 11 October 2005 :  15:58:57  Show Profile
I did, oh well...
Go to Top of Page
Page: of 7 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.49 seconds. Powered By: Snitz Forums 2000 Version 3.4.07