I have a database that has grown much larger than I expect. There is a
specific table that seems to be unusally large. If I copy the data from that
table out into a temp table then copy it back in, it frees up over 90% of th
e
space that it was taking up.
I cannot alter the database structure at this point so is there a better way
to free this space up ? I have tried things like shrinkdb and shrinkfile and
whilst they create a little space its not anywhere near the level of moving
the data.
Does anyone have any ideas ?
SiSimon
How large is your database? Do you have limited space on the disk?
1) You can put the large table on different physical disk array
2) You use partition to "divide" the table
BTW , what is the version are you using?
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:A58E5518-5D24-4FBC-AE57-C50D822F75BB@.microsoft.com...
>I have a database that has grown much larger than I expect. There is a
> specific table that seems to be unusally large. If I copy the data from
> that
> table out into a temp table then copy it back in, it frees up over 90% of
> the
> space that it was taking up.
> I cannot alter the database structure at this point so is there a better
> way
> to free this space up ? I have tried things like shrinkdb and shrinkfile
> and
> whilst they create a little space its not anywhere near the level of
> moving
> the data.
> Does anyone have any ideas ?
> Si|||How many indexes do you have on that table? How often do you rebuild
the indexes?
It looks like your table had a lot of fragmentation, which as a result
made t use a lot more space than necessary.
Markus|||The database is around 40Gig
But one table is 35G of that. When I copy the data out and then back in it
becomes around 3G.
I`m using SQL2000.
I know I can split the data onto seperate disks but I was hoping to write a
job that will shrink the data down automatically.
"Uri Dimant" wrote:
> Simon
> How large is your database? Do you have limited space on the disk?
> 1) You can put the large table on different physical disk array
> 2) You use partition to "divide" the table
> BTW , what is the version are you using?
>
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:A58E5518-5D24-4FBC-AE57-C50D822F75BB@.microsoft.com...
>
>|||Simon wrote:
> The database is around 40Gig
> But one table is 35G of that. When I copy the data out and then back in it
> becomes around 3G.
> I`m using SQL2000.
> I know I can split the data onto seperate disks but I was hoping to write
a
> job that will shrink the data down automatically.
>
As Markus said, this sounds like a fragmentation problem. Use DBCC
SHOWCONTIG to check the fragmentation of the indexes on that table, and
have a look at this script of mine:
http://realsqlguy.com/twiki/bin/vie...IndexesAsNeeded
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Showing posts with label copy. Show all posts
Showing posts with label copy. Show all posts
Sunday, March 25, 2012
Database Size problems
I have a database that has grown much larger than I expect. There is a
specific table that seems to be unusally large. If I copy the data from that
table out into a temp table then copy it back in, it frees up over 90% of the
space that it was taking up.
I cannot alter the database structure at this point so is there a better way
to free this space up ? I have tried things like shrinkdb and shrinkfile and
whilst they create a little space its not anywhere near the level of moving
the data.
Does anyone have any ideas ?
SiSimon
How large is your database? Do you have limited space on the disk?
1) You can put the large table on different physical disk array
2) You use partition to "divide" the table
BTW , what is the version are you using?
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:A58E5518-5D24-4FBC-AE57-C50D822F75BB@.microsoft.com...
>I have a database that has grown much larger than I expect. There is a
> specific table that seems to be unusally large. If I copy the data from
> that
> table out into a temp table then copy it back in, it frees up over 90% of
> the
> space that it was taking up.
> I cannot alter the database structure at this point so is there a better
> way
> to free this space up ? I have tried things like shrinkdb and shrinkfile
> and
> whilst they create a little space its not anywhere near the level of
> moving
> the data.
> Does anyone have any ideas ?
> Si|||How many indexes do you have on that table? How often do you rebuild
the indexes?
It looks like your table had a lot of fragmentation, which as a result
made t use a lot more space than necessary.
Markus|||The database is around 40Gig
But one table is 35G of that. When I copy the data out and then back in it
becomes around 3G.
I`m using SQL2000.
I know I can split the data onto seperate disks but I was hoping to write a
job that will shrink the data down automatically.
"Uri Dimant" wrote:
> Simon
> How large is your database? Do you have limited space on the disk?
> 1) You can put the large table on different physical disk array
> 2) You use partition to "divide" the table
> BTW , what is the version are you using?
>
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:A58E5518-5D24-4FBC-AE57-C50D822F75BB@.microsoft.com...
> >I have a database that has grown much larger than I expect. There is a
> > specific table that seems to be unusally large. If I copy the data from
> > that
> > table out into a temp table then copy it back in, it frees up over 90% of
> > the
> > space that it was taking up.
> > I cannot alter the database structure at this point so is there a better
> > way
> > to free this space up ? I have tried things like shrinkdb and shrinkfile
> > and
> > whilst they create a little space its not anywhere near the level of
> > moving
> > the data.
> >
> > Does anyone have any ideas ?
> >
> > Si
>
>|||Simon wrote:
> The database is around 40Gig
> But one table is 35G of that. When I copy the data out and then back in it
> becomes around 3G.
> I`m using SQL2000.
> I know I can split the data onto seperate disks but I was hoping to write a
> job that will shrink the data down automatically.
>
As Markus said, this sounds like a fragmentation problem. Use DBCC
SHOWCONTIG to check the fragmentation of the indexes on that table, and
have a look at this script of mine:
http://realsqlguy.com/twiki/bin/view/RealSQLGuy/DefragIndexesAsNeeded
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql
specific table that seems to be unusally large. If I copy the data from that
table out into a temp table then copy it back in, it frees up over 90% of the
space that it was taking up.
I cannot alter the database structure at this point so is there a better way
to free this space up ? I have tried things like shrinkdb and shrinkfile and
whilst they create a little space its not anywhere near the level of moving
the data.
Does anyone have any ideas ?
SiSimon
How large is your database? Do you have limited space on the disk?
1) You can put the large table on different physical disk array
2) You use partition to "divide" the table
BTW , what is the version are you using?
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:A58E5518-5D24-4FBC-AE57-C50D822F75BB@.microsoft.com...
>I have a database that has grown much larger than I expect. There is a
> specific table that seems to be unusally large. If I copy the data from
> that
> table out into a temp table then copy it back in, it frees up over 90% of
> the
> space that it was taking up.
> I cannot alter the database structure at this point so is there a better
> way
> to free this space up ? I have tried things like shrinkdb and shrinkfile
> and
> whilst they create a little space its not anywhere near the level of
> moving
> the data.
> Does anyone have any ideas ?
> Si|||How many indexes do you have on that table? How often do you rebuild
the indexes?
It looks like your table had a lot of fragmentation, which as a result
made t use a lot more space than necessary.
Markus|||The database is around 40Gig
But one table is 35G of that. When I copy the data out and then back in it
becomes around 3G.
I`m using SQL2000.
I know I can split the data onto seperate disks but I was hoping to write a
job that will shrink the data down automatically.
"Uri Dimant" wrote:
> Simon
> How large is your database? Do you have limited space on the disk?
> 1) You can put the large table on different physical disk array
> 2) You use partition to "divide" the table
> BTW , what is the version are you using?
>
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:A58E5518-5D24-4FBC-AE57-C50D822F75BB@.microsoft.com...
> >I have a database that has grown much larger than I expect. There is a
> > specific table that seems to be unusally large. If I copy the data from
> > that
> > table out into a temp table then copy it back in, it frees up over 90% of
> > the
> > space that it was taking up.
> > I cannot alter the database structure at this point so is there a better
> > way
> > to free this space up ? I have tried things like shrinkdb and shrinkfile
> > and
> > whilst they create a little space its not anywhere near the level of
> > moving
> > the data.
> >
> > Does anyone have any ideas ?
> >
> > Si
>
>|||Simon wrote:
> The database is around 40Gig
> But one table is 35G of that. When I copy the data out and then back in it
> becomes around 3G.
> I`m using SQL2000.
> I know I can split the data onto seperate disks but I was hoping to write a
> job that will shrink the data down automatically.
>
As Markus said, this sounds like a fragmentation problem. Use DBCC
SHOWCONTIG to check the fragmentation of the indexes on that table, and
have a look at this script of mine:
http://realsqlguy.com/twiki/bin/view/RealSQLGuy/DefragIndexesAsNeeded
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql
Monday, March 19, 2012
Database schema differences
Hello,
Is there any way to compare two schemas and see the differences. Usual
story - client has changed their database structure, sent me a new
copy and I need to know what's changed without looking at each
table...best I've come up with so far is to script each database and
look at the scripts in Notepad...me thinks there must be a better way.
Cheers
RayHi
Tools such as Red Gates SQL Compare, DBGhost etc can do that and also script
the changes needed to return it back to what it should be!
John
"rbrowning1958" <RBrowning1958@.gmail.com> wrote in message
news:91e2428a-0140-468c-8420-d3b3a09cb18f@.s37g2000prg.googlegroups.com...
> Hello,
> Is there any way to compare two schemas and see the differences. Usual
> story - client has changed their database structure, sent me a new
> copy and I need to know what's changed without looking at each
> table...best I've come up with so far is to script each database and
> look at the scripts in Notepad...me thinks there must be a better way.
> Cheers
> Ray|||The free, open-source SchemaCrawler for SQL Server tool will do this
for you. You can take human-readable snapshots of the schema and data,
for later comparison. Comparisons are done using a standard diff tool
such as WinMerge. SchemaCrawler outputs details of your schema
(tables, views, procedures, and more) in a diff-able plain-text format
(text, CSV, or XHTML). SchemaCrawler can also output data (including
CLOBs and BLOBs) in the same plain-text formats.
SchemaCrawler is available at SourceForge:
http://schemacrawler.sourceforge.net/
Sualeh Fatehi|||Try AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com
- you can easily compare structures of tables, procedures, functions,
views, triggers and relationships.
Comparison "sessions" can be saved and re-played later without the
need of re-entering the parameters;
command line parameter can be used to fully automate comparisons.
Dariusz Dziewialtowski.
Is there any way to compare two schemas and see the differences. Usual
story - client has changed their database structure, sent me a new
copy and I need to know what's changed without looking at each
table...best I've come up with so far is to script each database and
look at the scripts in Notepad...me thinks there must be a better way.
Cheers
RayHi
Tools such as Red Gates SQL Compare, DBGhost etc can do that and also script
the changes needed to return it back to what it should be!
John
"rbrowning1958" <RBrowning1958@.gmail.com> wrote in message
news:91e2428a-0140-468c-8420-d3b3a09cb18f@.s37g2000prg.googlegroups.com...
> Hello,
> Is there any way to compare two schemas and see the differences. Usual
> story - client has changed their database structure, sent me a new
> copy and I need to know what's changed without looking at each
> table...best I've come up with so far is to script each database and
> look at the scripts in Notepad...me thinks there must be a better way.
> Cheers
> Ray|||The free, open-source SchemaCrawler for SQL Server tool will do this
for you. You can take human-readable snapshots of the schema and data,
for later comparison. Comparisons are done using a standard diff tool
such as WinMerge. SchemaCrawler outputs details of your schema
(tables, views, procedures, and more) in a diff-able plain-text format
(text, CSV, or XHTML). SchemaCrawler can also output data (including
CLOBs and BLOBs) in the same plain-text formats.
SchemaCrawler is available at SourceForge:
http://schemacrawler.sourceforge.net/
Sualeh Fatehi|||Try AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com
- you can easily compare structures of tables, procedures, functions,
views, triggers and relationships.
Comparison "sessions" can be saved and re-played later without the
need of re-entering the parameters;
command line parameter can be used to fully automate comparisons.
Dariusz Dziewialtowski.
Database Schema copy
I want to a DB, and create an empty DB with the same schema. This was
preety easy with Enterprise Manager, how can I do it with the new suite?
Using Management Studio, right click on the database name and select "Script
Database as".
Mark
"Dave H" <DaveH@.noemail.nospam> wrote in message
news:BZmdnbmZgJx5Y-DeRVn-tQ@.comcast.com...
>I want to a DB, and create an empty DB with the same schema. This was
> preety easy with Enterprise Manager, how can I do it with the new suite?
>
|||I want the whole schema, that only does the DBCreate?
Dave
"mark sullivan" wrote:
> Using Management Studio, right click on the database name and select "Script
> Database as".
> Mark
>
> "Dave H" <DaveH@.noemail.nospam> wrote in message
> news:BZmdnbmZgJx5Y-DeRVn-tQ@.comcast.com...
>
>
|||Use the Generate Scripts Wizard: Right-click the database, point to Tasks,
and then click Generate Scripts.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Dave H" <DaveH@.discussions.microsoft.com> wrote in message
news:BBC90ED6-8824-4731-B29A-2B1F3A83B680@.microsoft.com...[vbcol=seagreen]
>I want the whole schema, that only does the DBCreate?
> --
> Dave
>
> "mark sullivan" wrote:
preety easy with Enterprise Manager, how can I do it with the new suite?
Using Management Studio, right click on the database name and select "Script
Database as".
Mark
"Dave H" <DaveH@.noemail.nospam> wrote in message
news:BZmdnbmZgJx5Y-DeRVn-tQ@.comcast.com...
>I want to a DB, and create an empty DB with the same schema. This was
> preety easy with Enterprise Manager, how can I do it with the new suite?
>
|||I want the whole schema, that only does the DBCreate?
Dave
"mark sullivan" wrote:
> Using Management Studio, right click on the database name and select "Script
> Database as".
> Mark
>
> "Dave H" <DaveH@.noemail.nospam> wrote in message
> news:BZmdnbmZgJx5Y-DeRVn-tQ@.comcast.com...
>
>
|||Use the Generate Scripts Wizard: Right-click the database, point to Tasks,
and then click Generate Scripts.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Dave H" <DaveH@.discussions.microsoft.com> wrote in message
news:BBC90ED6-8824-4731-B29A-2B1F3A83B680@.microsoft.com...[vbcol=seagreen]
>I want the whole schema, that only does the DBCreate?
> --
> Dave
>
> "mark sullivan" wrote:
Wednesday, March 7, 2012
database replication / publication ?
Hi,
I'd like to keep an extra copy for database X on SQL server A to SQL server
B. The database X doesn't update very often during the day (but the computer
does have other jobs to run at tthe work hour). Both server A and B run SQL
server 2000 and on the same network. Currently the size of database X's MDF
and LDF are around 6 GB (3GB each). It would be nice to keep database X
always be in sync with its copy, but it is not a must. If the database
replication/publication takes a lot of CPU or is time comsuing, it is OK to
do it with a nightly job.
What is the good practice in the case? Thanks for sharing your thoughts.
Shawn,
for an extra copy of X on a standby server, and where latency is allowed,
I'd consider using Log Shipping. This article helps explain some of the key
differences: http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
I'd like to keep an extra copy for database X on SQL server A to SQL server
B. The database X doesn't update very often during the day (but the computer
does have other jobs to run at tthe work hour). Both server A and B run SQL
server 2000 and on the same network. Currently the size of database X's MDF
and LDF are around 6 GB (3GB each). It would be nice to keep database X
always be in sync with its copy, but it is not a must. If the database
replication/publication takes a lot of CPU or is time comsuing, it is OK to
do it with a nightly job.
What is the good practice in the case? Thanks for sharing your thoughts.
Shawn,
for an extra copy of X on a standby server, and where latency is allowed,
I'd consider using Log Shipping. This article helps explain some of the key
differences: http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Saturday, February 25, 2012
Database Refreshes
Has anyone come across any useful scripts to copy database backups from live
and restore onto dev servers?You are not talking about something like Log Shipping, right?
--
Ekrem Ã?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from live
> and restore onto dev servers?
and restore onto dev servers?You are not talking about something like Log Shipping, right?
--
Ekrem Ã?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from live
> and restore onto dev servers?
Database Refreshes
Has anyone come across any useful scripts to copy database backups from live
and restore onto dev servers?
You are not talking about something like Log Shipping, right?
Ekrem ?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?
|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from live
> and restore onto dev servers?
and restore onto dev servers?
You are not talking about something like Log Shipping, right?
Ekrem ?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?
|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from live
> and restore onto dev servers?
Database Refreshes
Has anyone come across any useful scripts to copy database backups from live
and restore onto dev servers?You are not talking about something like Log Shipping, right?
Ekrem ?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from li
ve
> and restore onto dev servers?
and restore onto dev servers?You are not talking about something like Log Shipping, right?
Ekrem ?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from li
ve
> and restore onto dev servers?
Database refresh question
There's a sql server 2000 database that was created as a copy of another db, let's say db1 and copy_of_db1. db1 has been updated (structure and data) since copy_of_db1 was created, while copy_of_db1 has remained static. I now need to update copy_of_db1 to be in sync with db1 and use copy_of_db1 so I can drop db1. What would be the fastest and most efficient way to update copy_of_db1 to mirror the current db1?
Backup the updated one and restore it, in the Backup and restore wizard choose the restore from device option you also have the option to change the name of the restored one. Hope this helps.
|||Thanks!Friday, February 24, 2012
Database recovery issue
Hi guys
I am trying to open a database which is on a shared drive. The database is
stored in the 'my network places'. Now when I try to copy the database into
my hard disk, it says "sharing violation, file in use' whereas nobody else is
using it except me.
SQL does not recognise the shared path as it is installed locally on my hard
disk.
Im using sql server 2005
PLease help guys
I'm not clear on what you mean by the last part of "SQL does
not recognise the shared path as it is installed locally on
my hard disk". You don't want to use network shares for SQL
Server data, log files.
In terms of not being able to access the files to copy to
your hard drive, you can use FileMon from sysinternals to
see what process or what user has the files in use:
http://www.sysinternals.com/Utilities/Filemon.html
-Sue
On Sun, 5 Nov 2006 11:39:02 -0800, mita
<mita@.discussions.microsoft.com> wrote:
>Hi guys
>I am trying to open a database which is on a shared drive. The database is
>stored in the 'my network places'. Now when I try to copy the database into
>my hard disk, it says "sharing violation, file in use' whereas nobody else is
>using it except me.
>SQL does not recognise the shared path as it is installed locally on my hard
>disk.
>Im using sql server 2005
>PLease help guys
I am trying to open a database which is on a shared drive. The database is
stored in the 'my network places'. Now when I try to copy the database into
my hard disk, it says "sharing violation, file in use' whereas nobody else is
using it except me.
SQL does not recognise the shared path as it is installed locally on my hard
disk.
Im using sql server 2005
PLease help guys
I'm not clear on what you mean by the last part of "SQL does
not recognise the shared path as it is installed locally on
my hard disk". You don't want to use network shares for SQL
Server data, log files.
In terms of not being able to access the files to copy to
your hard drive, you can use FileMon from sysinternals to
see what process or what user has the files in use:
http://www.sysinternals.com/Utilities/Filemon.html
-Sue
On Sun, 5 Nov 2006 11:39:02 -0800, mita
<mita@.discussions.microsoft.com> wrote:
>Hi guys
>I am trying to open a database which is on a shared drive. The database is
>stored in the 'my network places'. Now when I try to copy the database into
>my hard disk, it says "sharing violation, file in use' whereas nobody else is
>using it except me.
>SQL does not recognise the shared path as it is installed locally on my hard
>disk.
>Im using sql server 2005
>PLease help guys
Subscribe to:
Posts (Atom)