moving...

Hi ,

We have a database around 5GB in size, located in remote location . i want to get that database into my local machine. We cannot take back up in tape or any other media from our remote location ,so we have to depend on FTP .

Is there any better solution other than FTP, or DTS import/Export , to transfer whole database to my local machine ?

Please give me some suggestions !

Thanks,

HadleyIts better to take file backup and use FTP to transfer the file. Before than make sure to run DBCC checks against the database to keep it clean.

Even you can use Generate SQL Scripts and run those scripts on the local machine, then use DTS to transfer the data.

HTH

Moving tempdb

Hi,
We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
Tempdb is around 5GB or 7GB in size and is killing performance.
We want to move tempdb to a volume on the machine (e.g. T which has 40GB
free) so that we do not cause any problems on C:\.
Can you please tell me how we do this. Maybe links on the web with step by
step instructions would be useful.
SkcYou will find it in BOL, look for "Moving tempdb".
AMB
"Skc" wrote:
> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step by
> step instructions would be useful.
> Skc|||there is an example in BOL, under "ALTER DATABASE", look for "Move the tempdb
database".
AMB
"Alejandro Mesa" wrote:
> You will find it in BOL, look for "Moving tempdb".
>
> AMB
>
> "Skc" wrote:
> > Hi,
> >
> > We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> > Tempdb is around 5GB or 7GB in size and is killing performance.
> >
> > We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> > free) so that we do not cause any problems on C:\.
> >
> > Can you please tell me how we do this. Maybe links on the web with step by
> > step instructions would be useful.
> >
> > Skc|||As I replied within .setup:
The steps are described within this KB article:
http://support.microsoft.com/?id=224071
--
Keith
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:3DA1E004-3A30-4524-BCE9-539F3EBF1123@.microsoft.com...
> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step
by
> step instructions would be useful.
> Skcsql

Moving tempdb

Hi,
We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
Tempdb is around 5GB or 7GB in size and is killing performance.
We want to move tempdb to a volume on the machine (e.g. T which has 40GB
free) so that we do not cause any problems on C:\.
Can you please tell me how we do this. Maybe links on the web with step by
step instructions would be useful.
Skc
You will find it in BOL, look for "Moving tempdb".
AMB
"Skc" wrote:

> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step by
> step instructions would be useful.
> Skc
|||there is an example in BOL, under "ALTER DATABASE", look for "Move the tempdb
database".
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> You will find it in BOL, look for "Moving tempdb".
>
> AMB
>
> "Skc" wrote:
|||As I replied within .setup:
The steps are described within this KB article:
http://support.microsoft.com/?id=224071
Keith
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:3DA1E004-3A30-4524-BCE9-539F3EBF1123@.microsoft.com...
> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step
by
> step instructions would be useful.
> Skc

Moving tempdb

Hi,
We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
Tempdb is around 5GB or 7GB in size and is killing performance.
We want to move tempdb to a volume on the machine (e.g. T which has 40GB
free) so that we do not cause any problems on C:\.
Can you please tell me how we do this. Maybe links on the web with step by
step instructions would be useful.
SkcYou will find it in BOL, look for "Moving tempdb".
AMB
"Skc" wrote:

> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step b
y
> step instructions would be useful.
> Skc|||there is an example in BOL, under "ALTER DATABASE", look for "Move the tempd
b
database".
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> You will find it in BOL, look for "Moving tempdb".
>
> AMB
>
> "Skc" wrote:
>|||As I replied within .setup:
The steps are described within this KB article:
http://support.microsoft.com/?id=224071
Keith
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:3DA1E004-3A30-4524-BCE9-539F3EBF1123@.microsoft.com...
> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step
by
> step instructions would be useful.
> Skc