Database Restoration

Hi!
Could anyone please advice me on whether I could restore
database from a map drive ? This is due to space
limitation of the existing server...
Any other suggestions would be much appreciated..
TIAIt generally work (I've seen some issues with backup/restore over the
network, mainly for larger backups). Worth a try. Make sure that the SQL
Server service account has permissions on the share, and address using UNC
naming.
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> Hi!
> Could anyone please advice me on whether I could restore
> database from a map drive ? This is due to space
> limitation of the existing server...
> Any other suggestions would be much appreciated..
> TIA|||Could you provide me the steps cause i have tried it and
could not view the map drive from Enterprise Manager...
on NT4 platform MSSQL 7.0 server.
TIA
>--Original Message--
>It generally work (I've seen some issues with
backup/restore over the
>network, mainly for larger backups). Worth a try. Make
sure that the SQL
>Server service account has permissions on the share, and
address using UNC
>naming.
>--
>Tibor Karaszi
>
>"NG" <angiecmf@.hotmail.com> wrote in message
>news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
>> Hi!
>> Could anyone please advice me on whether I could restore
>> database from a map drive ? This is due to space
>> limitation of the existing server...
>> Any other suggestions would be much appreciated..
>> TIA
>
>.
>|||Don't use mapped drives, just enter the path as an UNC path:
\\servername\sharename\filename
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
> Could you provide me the steps cause i have tried it and
> could not view the map drive from Enterprise Manager...
> on NT4 platform MSSQL 7.0 server.
> TIA
> >--Original Message--
> >It generally work (I've seen some issues with
> backup/restore over the
> >network, mainly for larger backups). Worth a try. Make
> sure that the SQL
> >Server service account has permissions on the share, and
> address using UNC
> >naming.
> >
> >--
> >Tibor Karaszi
> >
> >
> >"NG" <angiecmf@.hotmail.com> wrote in message
> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> >> Hi!
> >>
> >> Could anyone please advice me on whether I could restore
> >> database from a map drive ? This is due to space
> >> limitation of the existing server...
> >> Any other suggestions would be much appreciated..
> >> TIA
> >
> >
> >.
> >|||i encountered error "Unable to verify the existence of the
backup file location". Do you want to use the backup file
location anyway? and
Microsoft SQL-DMO (ODBC SQLState: 42000)
"Cannot open backup
device '\\Etax_media\temp\tna_sen.bak'. Device error or
device off-line. Backup or restore operation terminating
abnormally"
Please help! Thanks
>--Original Message--
>Don't use mapped drives, just enter the path as an UNC
path:
>\\servername\sharename\filename
>--
>Tibor Karaszi
>
>"NG" <angiecmf@.hotmail.com> wrote in message
>news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
>> Could you provide me the steps cause i have tried it and
>> could not view the map drive from Enterprise Manager...
>> on NT4 platform MSSQL 7.0 server.
>> TIA
>> >--Original Message--
>> >It generally work (I've seen some issues with
>> backup/restore over the
>> >network, mainly for larger backups). Worth a try. Make
>> sure that the SQL
>> >Server service account has permissions on the share,
and
>> address using UNC
>> >naming.
>> >
>> >--
>> >Tibor Karaszi
>> >
>> >
>> >"NG" <angiecmf@.hotmail.com> wrote in message
>> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
>> >> Hi!
>> >>
>> >> Could anyone please advice me on whether I could
restore
>> >> database from a map drive ? This is due to space
>> >> limitation of the existing server...
>> >> Any other suggestions would be much appreciated..
>> >> TIA
>> >
>> >
>> >.
>> >
>
>.
>|||The first message is some tool (or rather, API) message, not an engine
message. The second is an engine message. It seems that the path is
incorrect or that the SQL Server service account don't have permissions on
the share.
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:0aff01c3a2ab$d4f047d0$a401280a@.phx.gbl...
> i encountered error "Unable to verify the existence of the
> backup file location". Do you want to use the backup file
> location anyway? and
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> "Cannot open backup
> device '\\Etax_media\temp\tna_sen.bak'. Device error or
> device off-line. Backup or restore operation terminating
> abnormally"
> Please help! Thanks
> >--Original Message--
> >Don't use mapped drives, just enter the path as an UNC
> path:
> >\\servername\sharename\filename
> >
> >--
> >Tibor Karaszi
> >
> >
> >"NG" <angiecmf@.hotmail.com> wrote in message
> >news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
> >> Could you provide me the steps cause i have tried it and
> >> could not view the map drive from Enterprise Manager...
> >> on NT4 platform MSSQL 7.0 server.
> >> TIA
> >>
> >> >--Original Message--
> >> >It generally work (I've seen some issues with
> >> backup/restore over the
> >> >network, mainly for larger backups). Worth a try. Make
> >> sure that the SQL
> >> >Server service account has permissions on the share,
> and
> >> address using UNC
> >> >naming.
> >> >
> >> >--
> >> >Tibor Karaszi
> >> >
> >> >
> >> >"NG" <angiecmf@.hotmail.com> wrote in message
> >> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> >> >> Hi!
> >> >>
> >> >> Could anyone please advice me on whether I could
> restore
> >> >> database from a map drive ? This is due to space
> >> >> limitation of the existing server...
> >> >> Any other suggestions would be much appreciated..
> >> >> TIA
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

database performance very bad, any advice?

check cpu, harddisk queue, read & write, memory usage, all very normal.

but one purticular database is very slow( all others are normal). it took 10 seconds to insert one record into the slow database. each record is less than 300 byte, all varchar. now there are 1 million records in the core table.

use DBCC showcontig to check the slow db, found out this:

Extent Scan Fragmentation -- 99.47%

will a "DBCC indexdefrag" help in this case?

Thanks for any help!Possible causes for poor performance:

* Statistics out of date. Use auto update statistics option or UPDATE STATISTICS

* Slow insert, could be due to the indexes needing an update with say a 90% fill factor. Don't use clustered index for data that is always changing.

* Have you got too many indexes?

* Try using data striping using file groups. Eg if you have 2 heavily used tables in a database, performance would be better if they were on separate disks / RAID arrays

* Is your transaction log being truncated (normally happens when tranaction log is backed up). Use DBCC sqlperf(logspace) .

* Is your transaction log file expanding every time you add more data?

* Is your database file expanding every time you add more data?

* Have you tried a DBCC checkdb ?

* Use NT Performance monitor to look at Disk, CPU and Memory activity counters.