Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-23 : 22:03:20
|
| Deven writes "I want to create multiple databases depending on each financial year ( eg FY2000, FY2001 ,FY2002..... etc & HISTORY) but at any given time my server should have only 3 instances of these different databases eg last year's data , current year's data and history database . I don't want to have data of previous to previous or earlier than that databases 1)I know how to create databases but how can i remove the instances of earlier databases which i don't require , I want to do all this drudgery programmatically2)Is there any possibility of taking database on a CD-R so that it becomes a backup copy and which can be restored again as and when required ( database size won't be more than 400MB).Thanx in advanceRegards,Deven" |
|
|
|
|
|
Adding & Removing Databases