I noticed that my data base in one of the Locations is 250gb, in the other locations the data base is no more than 500MB aprox.
How can I fix this problem, I reindex the data base and it is still the same size. When I did a Backup and try to restore it in another PC, an error occured and it didn't finish restoring it.
Help!
Usually the database has a 2gb or 4gb limit with msde or sql2005exp but the log file can grow to fill the hard drive. If it's the .ldf file, this query could fix it:
find the log file name: select name from sysfiles set size growth limit: dbcc shrinkfile("logfilename_log",2) use minimal logging: alter database "databasename" set recovery simple
If your database is corrupted where a re> I noticed that my data base in one of the Locations is 250gb, in the other
sorry, missed a step:
f> Usually the database has a 2gb or 4gb limit with msde or sql2005exp but the
Have something to add? Share your thoughts — no account required.
Ask the community — no account required