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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.